I know this subject has probably been covered before, but I can't seem to find it. If one is using VFP on the front and connecting to either Oracle or SQL-Server and desires to inform user 2 that user 1 has already retrieved a specific record, how are others here doing that without our lovely RLOCK() for VFP data?

I suppose one could add a locked field to a table and set it when user 1 retrieves the record. Your process would read that as user 2 tried to retrieve the same record and indicate that it is locked.
The problem I see in that is in the event of a crash, a module would need to run to update all lock flags back to unlocked before anyone could re-enter the app.

So, what are some of the approaches to simulate a pessimistic environment for non-VFP data?

Steve