Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index > Multi-User Guide > Multi-User Concurrency Settings > Table Locks

Displaying Multi-User Locks

Scroll Prev Top Next More

When R:BASE is used on a network, the LIST command displays the names of any locked tables with a letter next to the table name for the type of multi-user lock.

 

The LIST TABLE command tells you whether the lock is an edit, cursor, row, local, or remote lock, as shown in the below table. The LIST TABLE LOCK command lists all locked tables within the database.

 

Letter

Lock

Description

r

Row lock

Another workstation is using EDIT ALL or a form that accesses this table or other commands that use row locks

L

Local lock

The SET LOCK command was issued from this workstation

R

Remote lock

A table lock has been applied with a command issued at another workstation

C

Cursor lock

A cursor is open on the table