Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get next number from SQL Server
Message
 
 
To
20/11/2006 13:16:04
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01171148
Message ID:
01171245
Views:
6
Jerry,

No, the update is a single implicit transaction. So two people can't get the same value out.

>Using the UPDATE, would it be possible to have two or more users hit the routine at the same time and receive the same value? In VFP we would RLOCK the record to avoid this situation.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform