>>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"

Fabio,

thank you.

This seems to be excellent hack to fix this issue in VFP!

Are you or anybody other using this in real VFP applications ?
What are possible drawbacks with this usage ?