Hi!

What is a buffering for views: row or table (3-d or 5-th)? If row, then data might be already updated automatically because record moving.

Rollback does not revert all data, RollBack leaves data in views as they where before all tableupdates().

Why you use TableRevert() here? This function will revert also user's changes. When user typed a ot of data, reverting when some problem will cause that user will require to type all data again. So changes in the views will be available, and user can correct them and submit data again for saving. Tablerevert is useful revert all user's changes by "Cancel" button or when exiting form without saving.

>Sorry it must be:
>

>Begin Transaction
>lUpdate = TableUpdate(1,.T.,"MyRvAlias1")
>If lUpdate
>   lUpdate = TableUpdate(1,.T.,"MyRvAlias2")
>Endif
>If lUpdate
>   lUpdate = TableUpdate(1,.T.,"MyRvAlias3")
>Endif
>If lUpdate
>   End Transaction
>Else
>   Rollback
>   =TableRevert(.T.,"MyRvAlias1")
>   =TableRevert(.T.,"MyRvAlias2")
>   =TableRevert(.T.,"MyRvAlias3")
>Endif
>

>Problem is if MyRvAlias1 commits successfully but MyRvAlias2 does not, the Rollback does not restore the original values of both tables. Am I missing something?
>
>BTW, my database is still pure VFP, but sooner we will upgrade it to SQLServer 2000 that's why we are using RVs and SPTs.