Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Soft locks and table buffering
Message
From
17/09/2002 11:49:51
Irv Adams
MSC Managed Care, Inc.
Florida, United States
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00700960
Message ID:
00701317
Views:
15
We used to do this (SoftLock) in the Fox 2.6 days and haven't been specific at the User-level since, but I am very interested in this thread...I would like to figure a way to do this myself in VFP.

The TableUpdate() command will return Record #s for un-updateable records as an Error array, if these could be captured beforehand somehow...

Just some thoughts.

-Irv.

>I'm curious how people normally handle soft record locks with buffering? (In case I have my terms wrong, I mean where you put who has the record locked and since when into the record rather than using RLOCK()).
>
>Since the table is buffered, no one else in the system will see the change to the lock status fields unless I do a tableupdate. So when the user wants to edit/add, I change those fields, update the table, and then let them edit. When they cancel or save, I have to change them again and update the table again.
>
>I just get the feeling I'm doing things the hard way. Is this normally done in a better way?
>
>Thanks,
>
>Michelle
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform