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.comWould you believe Far Side Lite?
More than 270 original cartoons.