Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serious Question about TableUpdate and Transactions
Message
From
16/10/2001 14:54:40
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Serious Question about TableUpdate and Transactions
Miscellaneous
Thread ID:
00569201
Message ID:
00569201
Views:
48
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!
Next
Reply
Map
View

Click here to load this message in the networking platform