>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 && returns 'xyz'
>begin transaction
>     TableUpdate( 2, .F., 'myview' )
>rollback
>? myview.myfield && still returns 'xyz', not 'abc'
>

Very interesting, I did not know this.. Hopefully I will have time after finishing what I have already started, and play around with updates and transactions some more, to be able to understand better. Thank you for your replies, they have been helpful!

---
Jonathan Chan