Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding locking conflicts with SQL -INSERT
Message
From
19/03/2001 17:03:55
Brent Smith
Guardian Life Insurance Company
Spokane, Washington, United States
 
 
To
19/03/2001 16:47:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00486550
Message ID:
00486648
Views:
11
I don't use an FLOCK() in my usual method, rather I use an RLOCK() on the keys table to assure that only one user is adding at one time. I can't use RLOCK() for an INSERT, but it occurs to me that an implicit FLOCK must be placed on the target table to append a record. Too simple for a sharp guy like me <g>.

Thanks
Brent
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform