General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
So, when you say "WORKGROUP" in caps is that to firmly tell us that it is a peer-to-peer network arrangement?
If so then what is the OS of the system that houses the data? **IF** it is Win2K then have a look at the UT Bug List #26. It dewcribes a different symptom but sounds like it could be related.
good luck
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only