Larry, I had a similar situation with a stuck cursor lock on a table. I had a cursor declared on a view containing that table and in the while loop, I was updating the table. While I didn't experience any trouble while developing, once it was installed in a multi-user environment, the cursor lock kept getting stuck. So I projected the view into a temp table and ran the loop on that. That appears to have corrected the issue, as I haven't had the lock get stuck since I did that.
As far as any tricks...I'd like to know too. (Set lock off doesn't work.) Dawn -----Original Message----- From: Lawrence Lustig [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 11: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
