>>>>>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,
then:
if you use TRANSMANUAL the ODBC Driver it sends a ROLLBACK when a error happen
if you use TRANSAUTO and send a ROLLBACK the ODBC Driver it collapses.

Search for a alternative ODBC driver, or changes backend.

I don't use Postgres, but this is enough not to use in the future it.

To understand:
1. you could capture the flow of the commands ODBC
and to see what it happens before the collapse.

2. if you open a connection and send these two commands:
- sqlexec (, "BEGIN TRAN")
- sqlexec (, "ROLLBACK")
what does it happen?

Fabio