Hi ,

I'm trying to do the following [this works fine in VFP]

semaphore table contains (tablename, id, username)

If user wants to edit a particular order say,
I look for the tablename+id in the semaphore table.
If found I try to rlock it (in case previous user crashed etc) if I can rlock it then user can edit it.
if not found then add record + rlock() it...

I was hoping I would be able to write a SP to do the above and return true if successful.

This is the only way I can think of to implement a pessimistic locking strategy...

Regards

Kal