First, are you looking at the data after the rollback? You haven't done a TABLEREVERT() so the changes are still in the buffer.
Are you sure all the aliases are in a DBC? I know you said you're using remote views, but is that for all the aliases, or only some of them?
>I am using remote views and having problem when updating multiple tables which is crucial as described below:
>
>
>
>BEGIN TRANSACTION
> IF TABLEU(.T.,'A') .AND.TABLEU(.T.,'B') .AND.TABLEU(.T.,'C') .AND. ....
> ENDTRANSACTION
> ELSE
> ROLLBACK
> ENDIF
>
><\pre>
>
>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 ?
>
>If I have known about this problem, I would have never used VIEWS, but it is too late. I am too deep in the application. If you find any answers please let me knoe too.
>
>
>Raz
