To archive some data in an other company before deleting I tried the following:

----------------------------------------------------------------
db.retry.point()
select tiitm001.*
from tiitm001 for update
where tiitm001._index1 = {something}
and tiitm001._compnr = <yy>
selectdo
tiitm001._compnr = <xy>
db.insert(ttiitm001,db.retry)
tiitm001._compnr = <yy>
db.delete(ttiitm001,db.retry)
endselect
commit.transaction()
-----------------------------------------------------------------

At the line "db.delete(ttiitm001,db.retry)" there is a error message "Table is not locked"


Is there any possibilty to solve this problem?

Thanks
Spartacus

Hi
You could use db.bind and use the returned pointer for the db.insert. I guess that should work.

Sunil