[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
+---------------------------------+
| SET MULTILOCKS |
+---------------------------------+
SET MULTILOCKS ON | OFF
-----------------------------------
Enables or disables multiple record locking in FoxPro/LAN.
Default value - OFF
-----------------------------------
FoxPro/LAN, the network version of FoxPro, provides the option of
attempting to lock more than one record in a database file. Depending
on the SETting of MULTILOCKS you may attempt to lock either a single
record or a set of records. Records may be locked with the LOCK() or
RLOCK() functions (LOCK() and RLOCK() can be used interchangeably).
. Note that toggling MULTILOCKS from ON to OFF or from OFF to ON
implicitly performs an UNLOCK ALL - all record locks in all work areas
are released.
For additional information on record locking, see LOCK() and RLOCK() in
this help facility.
ON
If MULTILOCKS is SET ON you may attempt to lock a set of records.
Multiple record locks may be attempted by including in LOCK() or RLOCK()
a set of record numbers. The record locks are attempted in the current
work area, or if a work area alias, work area letter or number is
included they may attempted in another work area.
OFF
If MULTILOCKS is SET OFF (the default value), a single record lock may
be attempted with LOCK() or RLOCK() on the current database record. A
record lock may be attempted in the current work area or in another work
area if a work area alias, work area letter or number is included. If a
record is locked, its lock will be released when a different record in
the same database is locked.
+---------------------------------+
| Program Example |
+---------------------------------+
SET MULTILOCKS ON
SELECT A
USE customer
? LOCK("1,2,3,4,5", 1)
? RLOCK("1,2,3,4,5", "customer")
-----------------------------------
See Also: LOCK(), RLOCK()
-----------------------------------
See Also:
LOCK()
RLOCK()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson