Yes. You need to find out why the table is locked. Table locks only
occur when certain commands are being executed against the database and
for varying amounts of time depending on the command. Table locks can
also be placed manually but if you are the developer, you'd know if that
was happening.
Here's some verbiage from the Help files that might help:
Multi-User Concurrency Control and Locking
Type of Lock Command Description
Concurrency Control
EDIT EDIT USING ENTER
Prevents one user from accidentally overwriting another user's changes.
These commands can access the same table simultaneously.
Row Lock
DELETE ROWS ENTER form FROM filespec INSERT values LOAD UPDATE
When SET ROWLOCKS is on, a lock is only applied to a row. When off, a
table lock is in effect.
Table Lock
BACKUP* DROP RULE FORMS GRANT INSERT subselect LABELS LOAD from filespec
REPORTS RESTORE REVOKE RULES SET LOCK ON UNLOAD*
Must wait for commands that obtain table and database locks. Once
obtained, this lock excludes all other concurrency control and locking
until these commands have finished.
Full Database Lock
BACKUP ALL RELOAD UNLOAD ALL
All tables in the database are locked.
Database Schema Lock
ALTER TABLE CREATE SCHEMA CREATE TABLE CREATE VIEW CREATE INDEX DROP
INDEX DROP COLUMN DROP TABLE DROP VIEW INTERSECT JOIN PROJECT RENAME
SUBTRACT UNION
Engages a full database lock preventing schema modifications, then
releases the schema lock remaining in table lock.
Cursor Lock
OPEN cursorname
Stops database schema commands but allows table locks; acts as a table
lock.
*A table lock is placed only if one table is unloaded. A database lock
is placed if more than one table is unloaded.
Hope this helps,
Steve
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aiko
Ichimura
Sent: Thursday, March 15, 2007 2:03 PM
To: RBASE-L Mailing List
Subject: [BULK] [RBASE-L] - Re: V 6.5
Importance: Low
OK,
Suppose a table I am trying to update has lock on it.
Then what do you do ? Can you do anything about it?
Thank you.
Aiko Ichimura
