Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wrapping all SQL updates into one transaction
Message
De
11/01/2000 11:32:05
 
 
À
11/01/2000 10:12:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00315804
Message ID:
00316259
Vues:
19
>In order to use SQLCOMMIT/SQLROLLBACK, you need to issue a SQLSETPROP for the connection immediately before the start of the changes being submited as a transaction, telling the backend to operate in Mnual Transaction mode. You can then submit SQLEXECs to you heart's content. Once you've finished, if all SQLEXECs completed successfully and you want the changes made committed, you issue a SQLCOMMIT, otherwise, a SQLROLLBACK. In order to prevent the next set of SQLEXECs from being treated as a manual transaction, you use SQLSETPROP to reset the transaction processing.

What would happen if the system hangs before it gets to SQLCOMMIT/SQLROLLBACK?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform