February 2, 2006
Tip of the Day #2: Clearing Stubborn Table Locks
Versions: R:BASE 7.5 and V-8 Turbo for Windows
Builds: 7.5.24.30202, 8.0.12.30202 or higher ...
In a multi-user environment, have you ever been
in a situation where a table is left locked and
you have no way to clear the lock(s), even
knowing that there is no one out there using
the same database?
Well, now you have the option to clear those
stubborn table locks by simply using the *new*
"CLEAR TABLE LOCKS" command.
Here's how:
DISCONNECT
SET MULTI OFF
CONNECT dbname
CLEAR TABLE LOCKS
This will CLEAR all stubborn table locks.
That's all there is to it!
(Of course, you must be using the current
version of R:BASE.)
Enjoy and make sure to have fun.
Very Best R:egards,
Razzak.
