Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique ID's in inventory systems
Message
From
19/05/1999 16:39:10
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00220153
Message ID:
00220616
Views:
27
>Jason,
>
>What happens if two or more users hit the NewID() method at the same exact time? Have you ever had this happen?

The Fox engine handles the conflict. Remember, the user is acting on a remote or local view of the data. The newid() method is only hit at the instant the user saves their changes to their new record. In the event that two users happened to save at the same instant, Fox puts one of them on hold for the fraction of a second that it takes to commit the other user's new record, and then commits the one on hold.

It has yet to miss with 100+ users on this system.

Regards,

J.
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage
Previous
Reply
Map
View

Click here to load this message in the networking platform