> I suppose to prevent users from actually having
> to redo their orders or whatnot, it would have
> to be stored in some manner before the transaction,
> so that it it fails, there is a mechanism to retry
> until it succeeds?
You probably won't need to do this.
When you do a ROLLBACK, VFP makes sures that none of the changes is actually commited to the database (even though you already sent a TableUpdate.)
The ROLLBACK will
not do a TableRevert in your view, and thus, after the ROLLBACK you will still have the data that the users inputed to your views/tables.
Let's say that the original value in a field was "abc", then your user modified to "xyz".
? myview.myfield
begin transaction
TableUpdate( 2, .F., 'myview' )
rollback
? myview.myfield
Hector Correa