>>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 ?
>
>Try this, but that way you handle transactions by your own.
>
>= SQLSETPROP(gnHandle, 'Transactions', 2)
>
Borislav,
Of course I use manual mode of transaction as I wrote in the beggining of my message.
My problem is that VFP automatically issues ROLLBACK command in case of error, even when manual transaction mode is in effect.
Andrus