>>>>Any idea how to disable this automatic ROLLBACK ?
>>>
>>>use DB_TRANSAUTO and
>>>- start the transaction with SQLEXEC(...,"BEGIN TRAN")
>>>- ....
>>>- end with SQLEXEC(...,"COMMIT TRAN") OR "ROLLBACK"
Fabio,
I found that SQLEXEC(... , "ROLLBACK" ) causes always GPF in VFP 7 & 9.
I'm using latest ( 08.00.0102 ) Postgres ODBC driver.
It seems that it is impossible to issue ROLLBACK command using SPT for Postgres SQL.
Andrus