Bde Error 8708
in SQL Explorer, but didntt had problems when doing the same thing in ISQL/w from SQL Server 6.5 ? More than that when i delete records in the same table they are not phisical deleted but no errors occurs. Thanks in regards Sandra Lino PS. Sorry about my poor english. Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't. Other Threads 1. BDE error Record/Key Deleted BDE-Error:8708 2. BDE Error 8708 accessing SQL Anywhere 3. BDE Error 8708: Record/Key Deleted working with InterBase 4. BDE Error 8708 "record/key deleted" 5. URGENT: 16bit BDE Error 8708 [$2204], Sorting ?? 6. BDE-Error 8708 7. BDE error $251E - An Error occurred while attempting to initialize the BDE 8. BDE Error $210D and BDE Error $2A04, dilemma !!! 9. Error occured while trying to initialize BDE, Error in modifying BDE 10. Application without BDE, but still BDE error?
documentation on it. This occurred in (I thought working code) when I deleted all the data in three related tables, and tried to insert new data. Basically I set the SQL statement, open the table, place in insert mode, set all the values and do a post. When the post occurs, the error Record/Key Deleted is generated (Category:34, ErrorCode:8708, Subcode:4). If I ignore this error code, the database entry appears correct as I observe with the ISQL utility. The only problem is that the http://www.delphigroups.info/2/d2/242584.html insert runs a trigger which uses a generator to generate a unique JobID. Although this appears to work (ISQL), the AutoRefresh does not get/set the new JobID back into the dataset, nor does a manual refresh get the JobID. Code Example follows: DM1->JobQ->Close(); DM1->JobQ->SQL->Clear(); DM1->JobQ->SQL->Add("Select * from JOBQUEUE"); DM1->JobQ->Prepare(); DM1->JobQ->Open(); DM1->JobQ->Insert(); DM1->JobQRECORDER->Value = Max + 100; DM1->JobQQUETIME->Value = http://www.delphigroups.info/2/eb/330556.html StrToDateTime(Now()); DM1->JobQAUTOMANUALREQ->Value = JOB_MANUAL; DM1->JobQSYSID->Value = 1; DM1->JobQBATCHNUMB->Value = bh->BatchID; DM1->JobQBATCHWEIGHT->Value = BWeight; DM1->JobQLIQUORVOLUME->Value = BVolume; DM1->JobQJOBSTATE->Value = BJS_INIT; // see MiscCode.h DM1->JobQCOMMENT->Value = bh->Comment; DM1->JobQRECIPE->Value = bh->FormulaName; DM1->JobQPRONAME->Value = bh->ProcedureName; DM1->JobQRGB1->Value = bh->Red; DM1->JobQRGB2->Value = bh->Green; DM1->JobQRGB3->Value = bh->Blue; DM1->JobQMACHNUMB->Value = bh->MachineNumb; DM1->JobQRECIPEID->Value = bh->FormulaID; try DM1->JobQ->Post(); } catch(EDBEngineError &x) { int i,j,k,l; i = x.Errors[0]->Category; j = x.Errors[0]->ErrorCode; k = x.Errors[0]->NativeError; l = x.Errors[0]->SubCode; } DM1->JobQ->Refresh(); x = DM1->JobQJOBID->Value; // Value here is 0, this does not update. // the value observed by ISQL is correct. Thanks in advance to anyone able to lend a hand here.......Tim C. Team Delphi Developer Sat
and BDE Version 2.52,Productversion 3.249 I have a table in the interbase like CREATE TABLE http://www.delphigroups.info/2/19/382021.html HPSchlag ( No INTEGER NOT NULL, http://www.verycomputer.com/158_80948b8f0f59a553_1.htm Text1 VARCHAR(20) NOT NULL COLLATE PXW_INTL, Text2 VARCHAR(20) NOT NULL COLLATE PXW_INTL, CONSTRAINT HPPKSchlag PRIMARY KEY (No,Text1), ); Now I insert 2 records. the first is [1,"1a23","monday"] then second is [1,"1A2","sunday"] Now bde error the TGrid show's the correct sorting order. [1,"1a23","monday"] [1,"1A2","sunday"] But if I reopen the TTable the order is [1,"1A2","sunday"] [1,"1a23","monday"] If I now try to change the second record from "monday" to something else a BDE Error $2204 [8708] occurs. Neither Delphi (Grids) nor the DataBaseDesktop can access this record. The interbase has sorted it bde error 8708 correctly. This behavior appears if the first string looks like [string1][lower case char][string2][string3] e.g. "1a23" or "AbCD" .... and the other string looks like [string1][upper case char][string2] e.g. "1A2" or "ABC" .... Is this a feature or is this a bug ??? Why differs the sorting order between BDE/Delphi and Interbase ??? Please mail any solutions to me. thanx in adv HMS -- Hinrich M. Schencking pro_Plant Gesellschaft fr Agrar- und Umweltinformatik mbH Nevinghoff 40, 48147 Mnster, Germany Tel.: ++49 251 2376-592, FAX : 2376-551 http://www.proplant.de EMail : h.schenck...@proplant.de Other Threads 1. BDE error Record/Key Deleted BDE-Error:8708 2. BDE ERROR 8708 3. BDE Error 8708 accessing SQL Anywhere 4. BDE Error 8708: Record/Key Deleted working with InterBase 5. BDE Error 8708 "record/key deleted" 6. BDE-Error 8708 7. BDE 16bit on NT 4 workstation NETAPI Error 8. Sort error problem -URGENT 9. ** VERY URGENT: BDE Error $2504 - Internal BDE bug? 10. Conflicts btwn 16bit BDE and 32bit BDE ??
it also deletes the detail records in the before delete event. So far so good, but If the master record was active then it gives me the error master/key deleted. I try to trap this error but it won't work.. Any suggestions? Thanks in advange Here is my code to trap the error while I have the constant eKeyOrrecDeleted = 8708 just above the implementation section procedure TDataMod.TblStaffDeleteError(DataSet: TDataSet; E: EDatabaseError; var Action: TDataAction); begin if (E is EDBEngineError) then if (E as EDBEngineError).Errors[0].Errorcode = eKeyOrrecDeleted then begin MessageDlg('The records are deleted succesfully.', mtInformation, [mbOK], 0); Abort; end; end; Top 1. Help:Record/Key Deleted message and Error message Numbers Hello I am rather new to programming and have a Delphi 3 application with a Master/Detail Table relationship. In the Master only one field is keyed and in the Detail two fields are keyed. No Autoincrement fields are used. When I try to edit one of the Keyed fields I keep getting (oh Boy am I tired of it) the Record/Key Deleted message. Have been trying to trap the error but am not succeding (maybe I should look for another occupation instead?). The same application written in Delphi 1 runs just fine (urrgh). Would be very thankful if somebody out there has any ideas on how to solve this problem. Also does anybody know if there is a list of all DatabaseEngine errors containing their appropriate numbers - can't make head or tail of DBIErrs.Int and IDAPI.h......... how do I know the constant for the base category??? Please forgive my questions if they are silly - but answer them anyway if you can. Lucien 2. Connection is busy problem 3. Help please with error: Record/Key deleted 4. Snapshot replication and order of application. 5. delete primary key records together with the foreign keys records 6. ULH errors 7. Error 3167 Record Deleted when there is no deleted record 8. Printer Commands 9. error in deleting a record which is foreign key 10. Record/Key deleted error message 11. BDE Error Record Key Deleted 12. "Record/Key Deleted" BDE Error 13. Record/Key deleted Error Message 1 post • Page:1 of 1 All times are UTC Board index Spam Report