>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)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.