Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Append/post vs AppendRecord |
Fri, Sep 3 2010 5:07 AM | Permanent Link |
Yavuz Ozdemir GEMAS A.S. | Tim,
I am recreating this thread. I use ElevateDB 2.03 Build 21, Ansi. I create a table with 25.000 records. if I append new record with append/post commands, everything is OK. But I use appendrecord command, EEDBError 300 raised. I did't use any transaction command. Error Message: Project xxx.exe raised exception class EEDBError with messagae 'ElevateDB Error #300 Cannot lock the table XYZ in the shema Default for write access.' The message raised in 2 minutes timeout. ------------------------ icd1:='001001'; icd2:='001002'; ind:=12; if TB2.Locate('FLD',IND,[]) then while not TB2.Eof do if TB2.fieldbyname('FLD').asinteger=IND then begin if TB1.Locate('OLCU;ICD1;ICD2', vararrayof([TB2.fieldbyname('OLCU').asinteger, icd1, icd2]),[])=false then TB1.appendrecord([TB2.fieldbyname('OLCU').asinteger,icd1,icd2]); TB2.next end else break; --------------------- Thanks Yavuz |
Fri, Sep 3 2010 12:32 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Yavuz,
<< I am recreating this thread. >> Thank you, and sorry about losing the other postings. << I use ElevateDB 2.03 Build 21, Ansi. I create a table with 25.000 records. if I append new record with append/post commands, everything is OK. But I use appendrecord command, EEDBError 300 raised. I did't use any transaction command. Error Message: Project xxx.exe raised exception class EEDBError with messagae 'ElevateDB Error #300 Cannot lock the table XYZ in the shema Default for write access.' >> Can you send me a project that replicates this ? I suspect that when you get this into a scaled-down project, that the problem may go away, but I will need a sample project to look at anyways. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Sep 4 2010 9:13 AM | Permanent Link |
Yavuz Ozdemir GEMAS A.S. | Tim,
<<Can you send me a project that replicates this ? I suspect that when you get this into a scaled-down project, that the problem may go away, but I will need a sample project to look at anyways.>> I send scaled-down project file to your e-mail address. Yavuz |
Mon, Sep 6 2010 12:00 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Yavuz,
<< I send scaled-down project file to your e-mail address. >> Okay, the issue is with the Locate, not the AppendRecord. However, using the Append..Post sequence will work around the issue for now. I'll have a fix as soon as possible. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Sep 6 2010 1:36 PM | Permanent Link |
Yavuz Ozdemir GEMAS A.S. | Tim,
<<Okay, the issue is with the Locate, not the AppendRecord. However, using the Append..Post sequence will work around the issue for now. I'll have a fix as soon as possible.>> Thanks Yavuz |
This web page was last updated on Tuesday, May 7, 2024 at 02:40 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |