[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
+---------------------------------+
|            SET LOCK             |
+---------------------------------+
SET LOCK ON | OFF

-----------------------------------
Enables or disables automatic record or file locking in FoxPro/LAN.
Default value - OFF
-----------------------------------

FoxPro/LAN does not place a lock on a file when executing commands which
require read-only access to a database file.

Commands that require read-only access to a database:

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

These commands do not change the contents of a database file while they
execute; by default access to the database is still available to other
users on the network.  It is possible that the database may be changed
while you are executing one of these commands.  For example, you may be
printing a report and another user changes a record that has already
been included in the report.  Your report now contains dated
information.

To insure that you are using the most current data you can SET LOCK ON.
If LOCK is SET ON these FoxPro/LAN commands will automatically lock a
database file.  This prevents all access to the database file except for
read-only use by other users on your network.

To allow shared access of database files with the commands listed above,
SET LOCK OFF.  SET LOCK OFF may be used if it isn't essential to be
using the most current information from a database file.

This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson