Share via


SET LOCK Command

Enables or disables automatic file locking in certain commands.

SET LOCK ON | OFF

Parameters

  • ON
    Specifies that the commands listed below automatically lock the table when they execute. This provides read-only access to other users on the network and ensures that you are using the most current data.
  • OFF
    (Default) Enables shared access of tables with commands listed below. Use SET LOCK OFF if you don't need the most current information from a table.

Remarks

Visual FoxPro doesn't place a lock on a file when executing commands that require read-only access to a table. These commands include the following:

Commands  
AVERAGE JOIN (both files)
CALCULATE LIST
COPY TO LABEL
COPY TO ARRAY REPORT
COUNT SORT
DISPLAY (with a scope) SUM
INDEX TOTAL

While they are executed, these commands don't change the contents of a table, and access to the table is available to other users on the network. Thus, the table can be changed while you are executing one of these commands. For example, you might begin printing a report by using REPORT before another user changes a record included in the report. Your report now contains outdated information.

SET LOCK is scoped to the current data session.

See Also

FLOCK( ) | LOCK( ) | RLOCK( ) | SET DATASESSION | SET MULTILOCKS