>>>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.
I must ommit this :o)
Maybe I began to read from second row, sorry.
I don't know then. I must run some tests tomorow and et you now the results.
I hope you'll find the answer before that.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.