Larry: Make sure that there are no cursors open for the table; I seem to remember that cursors will lock the table. If there are open cursors, check your code to see why your code is exiting abnormally, without dropping the cursors. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lawrence Lustig Sent: Tuesday, July 20, 2004 1:05 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Extra table locks I've noticed that I seem to be getting phantom table locks -- tables are locked (with an (L) in the LIST TABLES ouput) even when no one is in the table. I think these locks may be left around by forms. Is anyone experiencing anything similar? Right now, I have a table locked in an R:Base database being accessed by many users. The user who was editing the table (actually two tables, header and details) has exited R:Base, but the table lock is persisting. The other users are DOS users and their code never even looks at the table in question. I need to run an alter command against the table in question to add a column, but obviously the alter command fails because the table appears to be locked. -- Larry
