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

-----------------------------------
Specifies if database files will be opened for exclusive or shared use
on network.  Available only in FoxPro/LAN.
Default value - ON
-----------------------------------

SET EXCLUSIVE determines if database files opened on a network will be
available for exclusive use by one user, or may be shared by every user.

Changing the setting of EXCLUSIVE does not change the status of
previously opened databases.  For example, if a database is opened with
EXCLUSIVE SET ON, and EXCLUSIVE is later SET OFF, the database will
still retain its exclusive use status.

ON
        A database opened on a network when EXCLUSIVE is SET ON is made
available only to the user who opened the database.  The database is not
accessible to other users on the network.  Unlike FLOCK(), SET EXCLUSIVE
ON also prevents read-only access to all other users.  A file may also
be opened on a network for exclusive use by including EXCLUSIVE with
USE.  It is not necessary to perform record or file locking on a
database opened for exclusive use.

        Opening a database for exclusive use assures that the file will not be
changed by other users.  Some FoxPro/LAN commands require that a
database be opened for exclusive use before they may be executed.  These
commands are INSERT [BLANK], MODIFY STRUCTURE, PACK, REINDEX and ZAP.

        The default for SET EXCLUSIVE is ON.

OFF
        If a database is opened on a network with EXCLUSIVE SET OFF, the
database may be shared and modified by any user on the network.

-----------------------------------

See Also:  FLOCK(), LOCK(), RLOCK(), USE

-----------------------------------

See Also: FLOCK() LOCK() RLOCK() USE
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson