Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Begin transaction & sqlsetprop(handle,transactions,2)
Message
From
24/02/2004 02:45:46
Suhas Hegde
Dental Surgeon
Sirsi, India
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Begin transaction & sqlsetprop(handle,transactions,2)
Miscellaneous
Thread ID:
00880173
Message ID:
00880173
Views:
77
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.
Next
Reply
Map
View

Click here to load this message in the networking platform