Steve,
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.
This statement caught my attention. I read all programs in the system and
remember seeing "Set ROWLOCKS OFF"
before the form was accessed. This might be the reason of my problem.
Thanks for your help.
Aiko Ichimura
[EMAIL PROTECTED]
----- Original Message -----
From: "Steve Martin" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, March 15, 2007 5:11 PM
Subject: [RBASE-L] - RE: [BULK] [RBASE-L] - Re: V 6.5
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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
