Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
RELEASE Statement (DataBasic) (m618703+release_s.htm)
Unlocks items that have been locked for update.
RELEASE {{fileVar,} itemId} {SETTING settingVar}
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.
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.
RELEASE
Unlocks all items that have been locked by the program.
RELEASE F1,"RECORD"
Unlocks the item RECORD in the file specified by F1.