>I issue a lot of SQLEXEC() command during single backend transaction started by SQLSETPROP(this.nConnHandle,"Transactions",2)
>
>Some of those SQLEXEC() commands may fail. I need to contine with transaction in case of some types of backed errors.
>
>Unfortunately, if backend returns error as response to SQLEXEC(), VFP automatically sends ROLLBACK command to backend!
>This does not allow my application to continue with transaction.
>
>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"