>I posted this question a week or two ago and got no answer (well... none that I liked anyway :-))
>
>Is there a way I can tell which record(s) in a table are locked without scanning the table and checking for locks on each individual record?
>Even better, is there some way to tell who (or what process) has it locked?
I think if you want to check locks, you should really scan and check. You can built some mechanism to check who is 'lock holder', e.g. additional field which will be filled programmatically with oApp.userid anytime someone RLOCK() from application. Also, you can have some table (I call it 'locker.dbf') which check user name of 'form/process holders', if you want to provide one-user access to particular functionality.
Edward Pikman
Independent Consultant