Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Network record conflict - Record is in use by another user
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Network record conflict - Record is in use by another user
Miscellaneous
Thread ID:
00466139
Message ID:
00466139
Views:
60
I test for network conflicts on data entry forms by running two simultaneous EXEs for User #1 and User #2.

User #1 runs a form.
User #1 presses Edit button and starts editing record.
User #2 runs same form.
User #2 presses Edit button and gets my msg - Try later. Record in use.
That works. But...

User #2 moves to previous record and comes back to same record User #1 is still editing.
User #2 presses Edit button and gets system msg - Record is in use by another user.

Why does this happen? And how can I fix it?

I have ON ERROR trap where I test RLOCK() for .T. or .F. to display my msg. The first time User #2 pressed Edit button, RLOCK() was .F. and got my msg, but after User #2 moved the record pointer and returned to the original record RLOCK() was .T. and didn't get my msg, but got the system msg instead. I read that moving the record pointer can UNLOCK the record, but if User #1 is still editing the record, how can that happen?

Thanks for the help.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform