| Note | This command is defined in a header file and will be preprocessed by the X# preprocessor to a function call. If you disable the standard header (-nostddefs) files then this command will not be available. If you tell the compiler to use a different standard header file (-stddef ) then this command may also be not available |
Purpose
Change the setting that determines whether to open database files in exclusive or shared mode.
Syntax
SET EXCLUSIVE ON | OFF | (<lToggle>)
Arguments
| ON | Limits accessibility of a table opened on a network to the user who opened it. The table isn't accessible to other users on the network. Unlike FLOCK( ), SET EXCLUSIVE ON also prevents all other users from having read-only access. A file can also be opened on a network for exclusive use by including the EXCLUSIVE clause with the USE command. It isn't necessary to perform record or file locking on a table opened for exclusive use. |
| Opening a table for exclusive use ensures that the file can't be changed by other users. For some commands, execution isn't possible until a table is opened for exclusive use. These commands are PACK, REINDEX, and ZAP. |
| OFF | Allows a table opened on a network to be shared and modified by any user on the network. |
| lToggle | A logical expression which must appear in parentheses. True is equivalent to ON, False to OFF |
Description
SET EXCLUSIVE is functionally equivalent to SetExclusive().
Changing the setting of SET EXCLUSIVE doesn't change the status of previously opened tables. For example, if a table is opened with SET EXCLUSIVE set to ON, and SET EXCLUSIVE is later changed to OFF, the table retains its exclusive-use status.
Assembly
XSharp.RT.DLL
See Also
FLock(), NetErr(), RLock(), SetExclusive(), USE
