>The second user is runnin another part of the same application. I see what you mean about the RLOCK() thing. Even if it's locked a COPY TO will still get the record. I guess I need something to check for this and tell it not to get that record if it is true that it is being used. No command out there that does this for you?
Sure - RLOCK().
Your second user could SCAN the list of copied records, and try to RLOCK() each equivalent record in the original table. If an RLOCK() fails (e.g. on record 14), DELETE that record from the copied records.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up