Topic group Related topics

Determines whether dBASE Plus attempts to lock a shared table during execution of certain commands that read the table but don't change its data.

Syntax

SET LOCK ON | off

Description

Issue SET LOCK OFF to disable automatic file locking for certain commands that only read a table. This lets other users change data in the file while you access it with read-only commands. For example, you might want to issue SET LOCK OFF before using AVERAGE if you don't expect other users to alter the data in the table you're using significantly. Or, you might want to issue SET LOCK OFF before processing a range of records that other users aren't going to update.

The following commands automatically lock tables when SET LOCK is ON and don't lock tables when SET LOCK is OFF:

AVERAGE

CALCULATE

COPY (source file)

COPY MEMO

COPY STRUCTURE

COPY TO ARRAY

COPY STRUCTURE [EXTENDED] (source file)

COUNT

SORT (source file)

SUM

TOTAL (source file)

dBASE Plus continues to lock records and tables automatically for commands that let you change data whether SET LOCK is ON or OFF.

OODML

This setting is not applicable.