I have a form that I want to prevent multi-user editing on. I turned pessimistic buffering on and changed the global error handler to throw up a message whenever error 109 came up.
Works fine. If I open it twice, and make an edit to the record in one instance, I get the messagebox in the other instance.
HOWEVER....
If I save the changes in the first instance, and then save the (unmade) changes in the second instance, the second one overwrites the first one. What's the easiest way to deal with this? If I had the time and budget, I'd make it truly multi-user, with CURVAL() and OLDVAL() checking each field, but that isn't really an option.
My next choice is RLOCKing the record when I go into edit mode, but I'd rather work with buffering and implicit locking....