All:

VFP 7.0 sp1
Network is a WORKGROUP with a mixture of XP and 2000 Pro.

I have SET REPROCESS TO 5 and using private data sessions. All of my tables are all contained in a DBC with pessimistic table buffering (4) set ON. The net effect will be VFP will automatically perform a lock on the record when a user begins editing a field on the form.

In my Error event of the text box I'm capturing error 108--"Record is in use by another user". Within the Error event, I'm displaying a custom message that tells the user that another user has this record locked...(blah)(blah)(blah).

All of this is working ok. But a strange thing happens in the Error event--all of the other locks that the VFP/user has placed are unlocked. I'm not doing anything else in the Error event except displaying this custom message.

Does anyone know why all record locks are getting released in the Error evert?

Thanks!

--Paul