>I don't use an FLOCK() in my usual method, rather I use an RLOCK() on the keys table to assure that only one user is adding at one time. I can't use RLOCK() for an INSERT, but it occurs to me that an implicit FLOCK must be placed on the target table to append a record. Too simple for a sharp guy like me <g>.
Actually, according to the docs, INSERT - SQL only requires a table header lock, not an FLOCK(). To get this you can issue RLOCK(0) on the table.
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