Luc,
>
>In my case, this means that I cannot include multiple Datatier with different connection handle in the same Begin -- End transaction block?
SQL transactions don't interact with VFP transactions. If necessary, I've ben told you can tie together SQL transactions from more than one handle, but I've never done it. SQL transactions are going to by default tie together one tableupdate(), but you can also manually manage the transactions on the handle rather easily, like in VFP.
You can use VFP transactions with SQL transactions, so you can rollback the VFP remote view if the SQL update fails. At that point, you're not actually rollingback any "real" data changes with the VFP transaction, but just whether the cursor thinks it's updated the back-end and the oldval() values.
HTH