Syntax: SET ROWLOCKS ON/OFF
Default: ON
R:BASE uses row-level locking in a multi-user environment. This command causes R:BASE to lock only the required row for the current command instead of locking the entire table. For example, if multiple users are modifying the same table using the UPDATE command, R:BASE locks only the rows affected by each UPDATE. When ROWLOCKS is set off, R:BASE sets table locks during each UPDATE, regardless of how many rows are affected.
Using SET ROWLOCKS to Lock Rows
When R:BASE is running in multi-user mode, the user has the added capability of forcing R:BASE to use row-level locking on some R:BASE commands. By default, the SET ROWLOCKS command is set on. Setting ROWLOCKS off is not recommended if all users intend to update the same tables. R:BASE always uses row-level locking for the EDIT, EDIT USING, and ENTER commands.
