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.