I have had at least 2 customers where a transaction was saved inside of a
Begin Trans
select a table
lsucces=tableupdate(.t.,.t.)
if lsuccess
select another table
lsuccess=tableupdate(.t.,.t.)
endif
...
if lsuccess
end transaction
else
rollback
endif
This process updates 10 tables. However, with these 2 customers there are transactions that do not include anything saved after the third table is processed. I would have thought this is impossible but I have their data and it certainly happened. If a table is in tablebuffer mode and is updated with tableupdate(.t.,.t.) and multiple records need to be committed, but some of them do not get saved what does tableupdate return? This is not clear and I have not figured out how to set up a test.
Any help greatly appreciated.
Thanks!
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!