Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disable automatic ROLLBACK
Message
From
20/10/2005 14:26:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Disable automatic ROLLBACK
Miscellaneous
Thread ID:
01060812
Message ID:
01060812
Views:
51
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 ?
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform