Difference between revisions of "LOCKR"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Lock a record for exclusive use
 
Lock a record for exclusive use
Line 33: Line 31:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Manual Locking]]
 
[[Category:Manual Locking]]
 
[[Category:Manual Locking Commands]]
 
[[Category:Manual Locking Commands]]

Latest revision as of 17:16, 11 November 2009

Purpose

Lock a record for exclusive use


Syntax

LOCKR


See Also

CLEAR LOCKS, CLOSE DATABASES, DISPLAY STATUS, FLOCK(), LOCKF, RLOCK(), SET EXCLUSIVE, UNLOCK, USE


Description

The LOCKR command provides the facility to lock a record in the active table for exclusive use. LOCKR is similar to the RLOCK() function except that LOCKR suspends program execution until the lock is granted. In order to prepare a table for locking, SET EXCLUSIVE OFF must be in effect when you USE the table.

The LOCKR command works in conjunction with the UNLOCK command. Whenever you issue CLOSE DATABASES, UNLOCK, USE, QUIT or CLEAR LOCKS, then any active locks will be removed. You can see any active locks using the DISPLAY STATUS command. This command is not normally needed as the Recital/4GL performs automatic file and record locking.


Example

set exclusive off
use patrons index events, names
seek "ROMEO"
if found()
    lockr
    replace price with price * 1.2
    unlock
endif


Products

Recital Server, Recital