Sorry Aleksey,
I have made pressure on your answers because it is from much time that I waited for a clarification on this point.
The clarification is here:
>If connection is closed while there is in an active transaction, driver commits changes.
This point is very important, but i don't found any words on it in VFP Documentation and on MSDN.
This ODBC Driver behaviour is very strange for me.
I test it with C API.
On SQL Query Analyzer this command donnot exist
IF @@TRANCOUNT > 0 COMMIT TRAN
I do not read any ODBC book for know concept of transaction.
My knowledge of computer science sure have not been formed on the Microsoft documentation.
Fabio