What happens if you "Set lock tblname off" ?
Bernie Lis
----- Original Message -----
From: "Lawrence Lustig" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Thursday, June 23, 2005 11:02 AM
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
