Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Several tableupdates
Message
From
17/06/2008 09:27:49
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01324687
Message ID:
01324693
Views:
11
Include all TABLEUPDATE inside BEGIN TRANSACTION...END TRANSACTION. Use ROLLBACK if a TABLEUPDATE fail.

>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 ?
Previous
Reply
Map
View

Click here to load this message in the networking platform