I am trying to update a 2 tables (table1, & table2) by using the remote views (rv_table1 & rv_table2) as shown in the folloing code:

*-- Sample code
BEGIN TRANSACTION
IF TABLEU(.T., .T.,"rv_table1") .AND. TABLEUPDATE(.T., .T.,"rv_table2")
END TRANSACTION
ELSE
ROLLBACK
ENDIF
RETURN
*-- End

I am using buffering mode 5. If any one of the two table updates fails, I do get a ROLLBACK but data does get written to the underlying tables.
I use shared connection on the views.

Am I doing something wrong, any suggessionsssss..., please let me know..

Thanks!
Raz



The table1 & table2 are remote views.