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