>>>If connection is closed while there is in an active transaction, driver commits changes.
>>>
>>
>>Really? Do you mean if the connection is NORMALLY closed? I assume that's what you mean, cause if the connection to the server drops (pc dies) then I always thought the server rolled back.
>>
>>I assume you mean if I do something like:
>>
>>

>>nConn = sqlconnect(connection)
>>
>>SQLSetProp(nConn, "Transactions", DB_MANUAL)
>>
>>SQLExec("INSERT INTO MYTABLE VALUES MYVALUES")
>>
>>SQLDisq(nConn)
>>

>>
>>That the odbc driver will commit this? If so, interesting info.
>>
>>BOb
>

Bob,

It is very good you brought this up. I've double checked and it is actually not driver, but VFP forces transaction to be committed before connection is closed. This behavior goes back at least to VFP6 and most likely to the time when SPT was added to the product.

Still, something to be aware of for VFP developers.

Should the behavior be changed now? Not an easy question to answer.

Thanks,
Aleksey.