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

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

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

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

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