Hi Michelle,
I proposed a method using a separate locks table here:
Re: Tracking record locks by WinNT user Thread #
566971 Message #
567036More discussion on some of the issues involved at
RLOCK Thread #
576665 Message #
576665 (entire thread).
>I'm curious how people normally handle soft record locks with buffering? (In case I have my terms wrong, I mean where you put who has the record locked and since when into the record rather than using RLOCK()).
>
>Since the table is buffered, no one else in the system will see the change to the lock status fields unless I do a tableupdate. So when the user wants to edit/add, I change those fields, update the table, and then let them edit. When they cancel or save, I have to change them again and update the table again.
>
>I just get the feeling I'm doing things the hard way. Is this normally done in a better way?
>
>Thanks,
>
>Michelle
Steve Gibson