Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Begin transaction & sqlsetprop(handle,transactions,2)
Message
De
24/02/2004 02:45:46
Suhas Hegde
Dental Surgeon
Sirsi, Inde
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Begin transaction & sqlsetprop(handle,transactions,2)
Divers
Thread ID:
00880173
Message ID:
00880173
Vues:
79
hi,

title doesnt allow double quotes....

I would like to know the difference between 
SQLexec(handle,"BEGIN TRANSACTION")

** AND

sqlsetprop(handle,"Transactions",2)
other than more than 1 transactions can be started on the sql server by SQLexec(handle,"BEGIN TRANSACTION")
Which is better to control the all or none updates and the locks on the MS SQLserver.
Thanx in advance.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform