UNLOCK

Purpose

Release active table and record locks

Syntax

UNLOCK [ALL] [IN <alias>]

See Also

FLOCK(), LOCKF, LOCKR, RLOCK()

Description

The UNLOCK command releases any active file or record locks for the currently selected workarea. This command is only effective with shared tables.

ALL

If the optional ALL keyword is specified, then the active file and record locks are released for all workareas.

IN <alias>

The IN <alias> clause is used to release file or record locks in another workarea. Alias names may be assigned to tables with the USE command.

The UNLOCK command works in conjunction with the RLOCK() and FLOCK() functions, and the LOCKR and LOCKF commands. This command is supported to provide compatibility with Xbase, but is normally not needed as the Recital/4GL performs automatic file and record locking.

Example

set exclusive off
use patrons index events, dates, names
seek "PHANTOM"
// Lock record with dBASE III compatibility
do while not rlock()
    sleep 2
enddo
// NOTE Recital automatically locks the 
// record in the EDIT command.  The RLOCK()
// and UNLOCK are not really necessary.
edit
unlock

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer