Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Make transactional Pass Through updates
Message
De
04/05/2005 15:13:46
Charles Richard
Nvo Management Systems
Boisbriand, Québec, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Make transactional Pass Through updates
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Divers
Thread ID:
01010984
Message ID:
01010984
Vues:
72
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform