Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Several tableupdates
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Several tableupdates
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01324687
Message ID:
01324687
Views:
60
I am using 3 tables

All 3 are cursors in my form dataenvironment buffered as 5

At the save buttom I have this lines

***save 1
select table1
= tableupdate (.T.)

*** save2
select table2
= tableupdate (.T.)

*** save3
select table3
= tableupdate (.T.)


Suppose that one of the "saves" above fails
Two tables will be saved and this will lead to severe erros, even if a warning message is displayed to my users

Is there a way to revert all if one of the tables fail ?


Moises
Next
Reply
Map
View

Click here to load this message in the networking platform