Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record Locking
Message
From
05/01/2009 10:06:46
 
 
To
04/01/2009 22:34:50
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01370930
Message ID:
01371014
Views:
24
>We use optimistic table buffering. At least I think that's what's being use for this. Anyway, it seems that somewhere in our code something is happening where the locking is not working right. We are not sure where yet, but it looks like we have a valid Record-level lock, but another user can change the same record. What are some of the things we can look for? I was wondering if it was flushing (where is Jim when you need him?) but don't know enough about that. Any guidance appreciated.

IIRC, record locking only occurs when a TableUpdate() has been issued, therefore, someone else can edit the record and save changes before you do. One way around this is to use GetFldState() or use the nUpdateWhat param in your TableUpdate
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Reply
Map
View

Click here to load this message in the networking platform