Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate() & Tablerevert()
Message
 
To
31/12/1997 16:32:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00068701
Message ID:
00068745
Views:
24
>I have a question regarding the tableupdate() command. I was wondering if there was a way, programmatically, to check if a tableupdate() would succeed without it actually doing the update. Something along the lines of a PeekTableUpdate(). The reason for my question is that I have two tables that get updated at the same time and I would like my code to be more elegent in the case of one tableupdate() succeeding and the other one fails. Any suggestions would be helpful.
>
>Mark A. Struck

Mark, wrap your update code in a BEGIN TRANSACTION / END TRANSACTION command. Since each TableUpdate() will return a .T. if it succeeds you can watch for a .F. return, write the appropriate message to the user and do a ROLLBACK.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform