Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

ROWLOCKS

Scroll Prev Top Next More

Operating Condition

 

Syntax: SET ROWLOCKS ON/OFF

 

Mode: Multi-user

 

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.

 

See Also:

 

Environment Optimization