Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Make transactional Pass Through updates
Message
From
04/05/2005 15:13:46
Charles Richard
Nvo Management Systems
Boisbriand, Quebec, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Make transactional Pass Through updates
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Miscellaneous
Thread ID:
01010984
Message ID:
01010984
Views:
70
Hello all

I have code which posts a series SQLEXEC update and delete queries against
an "Adaptive Server Anywhere 8.0" database via ODBC.

Does anyone know how to make the series transactional, post them all on none? I.E. are there @@ BEGIN and @@COMMIT @@ROLLBACK type commands before and after or does this involve SQL PREPARE ???

I am a bit foggy on these concepts and I need a quick solution for my client.

TIA
Charles Richard
Charles Richard
NVO Management Systems
crichard@nvo.ca
Next
Reply
Map
View

Click here to load this message in the networking platform