Hi Grigore,

if you use SPT cursor, you have identical problem:

SQLSETPROP(lnHandle,"Transactions",2)
SQLEXEC(lnHandle, "UPDATE Table 1")
SQLDISCONNECT(lnHandle) && this send IF @@TRANCOUNT > 0 COMMIT TRAN

I donnot use SQLSETPROP(lnHandle,"Transactions",2),
i use

=SQLSETPROP(lnHandle,"Transactions",1),SQLEXEC(lnHandle, "BEGIN TRAN")

In fact RV donnot use global transactions ( Aleksey write this ),
but only implicit transaction for the update/insert/delete batch command.

When you declare a CA, you config CA for use a SPT connection.

CA is OK, is SPT ( from VFP3 ) bugged.

Fabio