RELEASE Statement

Unlocks items that have been locked for update.

Syntax

RELEASE {{fileVar,} itemId} {SETTING settingVar}

Syntax Elements

fileVar The name of the variable to which the name of the file was assigned via an OPEN statement.

If fileVar is not specified, the internal default fileVariable is used, that is, the file most recently opened without a fileVariable.

itemId The name of the locked item.

settingVar The name of a variable that is set to a value corresponding to a file I/O error code by the SETTING clause if an error occurs. The file I/O error codes are described in File I/O and IPC Error Codes.

Comments

If you specify an item-id but no file variable, the internal default file variable is used, which is the file most recently opened without a file variable.

If you specify an item that has been locked multiple times, the lock is not released until it has been unlocked the same number of times (this behaviour can be changed for compatibility with other MutliValue systems).

If you specify neither fileVar nor itemId, RELEASE unlocks all items locked by the program, including those that have been locked multiple times.

Note

Within a transaction, release is deferred until the transaction is completed or aborted.

Examples

RELEASE

Unlocks all items that have been locked by the program.

RELEASE F1,"RECORD"

Unlocks the item RECORD in the file specified by F1.