Ooops - thanks for the correction Jim.
>>Carmen,
>>
>>1) You *must* use table buffering;
>>2) You *must* use TABLEUPDATE()s on each of your tables;
>
>Jim,
>
>The above is not correct. It is not necessary to use buffering for transactions, it is necessary that the tables involved reside in a VFP database.
>
>I would also advise that with two different databases that each one have its own transaction, so that the psuedo code would be;
>
>
>BEGIN TRANSACTION
> Post to database A
> IF No Error
> BEGIN TRANSACTION
> Post to database B
> IF No Error
> * End 2nd txn
> ENDTRANSACTION
> * End 1st Txn
> ENDTRANSACTION
> ELSE
> * Rollback 2nd txn
> ROLLBACK
> * Rollback 1st Txn
> ROLLBACK
> ENDIF
> ELSE
> * Rollback 1st txn
> ROLLBACK
> ENDIF
>