Larry: I have found that many times when you exit a cursor abnormally, it leaves a lock. Do LIST CURSORS and if there is one, then DROP CURSOR your_cursor_name. 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: Thursday, June 23, 2005 10:02 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Stuck cursor lock. I have a database in which I need to drop and recreate a table. I cannot, because the table has a cursor lock on it. I don't know where the lock is coming from because no one is using this table (it is not accessible from the user menus -- it's under development). I need to get rid of the lock. I assume that getting everyone out and connecting in single user mode will do the trick, but that's difficult at this 24 x 7 installation (I'll try to do it at lunchtime). Does anyone know A) where this lock might be coming from and B) if there is any trick I can use with other users in the database to force R:Base to clear that lock? -- Larry
