Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Prompting for locked records
Message
From
19/02/1999 16:46:18
 
 
To
19/02/1999 16:10:01
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00189490
Message ID:
00189524
Views:
8
I certainly agree with what James is saying, but if you're asking how to first check to see if a record is locked, try updating the record, replacing a field with it's original value such as:

UPDATE names
SET names.first = names.first
WHERE names.keyid = "001"

If you're using pessimistic row locking and the update is successful, then you've just locked it and it's available for updating. Query the data for the fields you need and edit them as desired.

Hope this helps.
Previous
Reply
Map
View

Click here to load this message in the networking platform