>I have a form with a SAVE button. The CLICK of the button processes a TRANSACTION which updates three different tables. Is there a way to test for the over-all success of the transaction ? Or do I need to have individual TABLEUPDATE() commands within the transaction ? I would love to return a .T. or .F. Also, if the transaction is not successful, will the TABLEREVERT()s be automatic ?
>
>Any help is appreciated
During the TRANSACTION you need the TABLEUPDATE() on each table.
If one of these fails, TABLEREVERT() the one that failed, and ROLLBACK the transaction to take care of the tables that were already updated.
Insanity: Doing the same thing over and over and expecting different results.