Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is in use by another user
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Record is in use by another user
Miscellaneous
Thread ID:
00659506
Message ID:
00659506
Views:
63
Hi everybody,

We're still having a problem with couple of my applications, when the users get "Record is in use by another user" error message. This error has only Ok and Help buttons with not much info in it:
Record is in use by another user (Error 109)
You have attempted to write to a record that is locked by another user.

The typical scenario of the problem is:

15+ users are in the system doing different kind of jobs... Parcel Processors work each on his/her own workfile and nobody else is using the same workfile. They have a grid for editting. Sometimes the error message pops up immediatelly after they click on the textbox in the grid, sometimes after they press delete or backspace button. File is table buffered, all other tables are used for lookup purposes and used in shared noupdate mode (or they are read-only cursors). My colleague added ALIAS() and RECNO() to the error handler call, however it reports Login table, which is in different datasession and unrelavant for this application. The problem is sporadic, though could be reproduced...

Do you either experience this kind of problem and what would be your suggestions?

Thanks a lot in advance.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform