Sebastian's right, you can't use BEGIN...TRANSACTION with remote views. (I forgot about that when I replied in the other thread you mentioned this in.) You should try SQLCommit() and SQLRollback() instead. (Assuming you're writing to something like SQL Server.)

>I am trying to update 7 tables by using the following command:
>
>

>BEGIN TRANSACTION
>   IF TABLEU(.T.,'A') .AND.TABLEU(.T.,'B') .AND.TABLEU(.T.,'C') .AND. ....
>      ENDTRANSACTION
>   ELSE
>      ROLLBACK
>   ENDIF
>

>
>If the error is found on the first table, all tables rollback. But if the error is on the 3rd or higher table, the rollback works only on tables after the error. The table 1 & 2 get commited. Can anyone explain why this happens & how to work around it ?
>
>THANK YOU IN ADVANCE
>
>Raz