Difference between revisions of "SET LOCKWAIT"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Enable or disable automatic record locking | Enable or disable automatic record locking | ||
| Line 12: | Line 5: | ||
==Syntax== | ==Syntax== | ||
SET LOCK ON | OFF | (<expL>) | SET LOCK ON | OFF | (<expL>) | ||
| + | |||
SET LOCKWAIT ON | OFF | (<expL>) | SET LOCKWAIT ON | OFF | (<expL>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | FLOCK(), LOCK(), LOCKF, LOCKR, RLOCK(), UNLOCK | + | [[FLOCK()]], [[LOCK()]], [[LOCKF]], [[LOCKR]], [[RLOCK()]], [[UNLOCK]] |
| Line 25: | Line 18: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
use patrons index events, dates, names | use patrons index events, dates, names | ||
set filter to event = "HAMLET" | set filter to event = "HAMLET" | ||
| − | browse</ | + | browse</code> |
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
| + | [[Category:Documentation]] | ||
| + | [[Category:Commands]] | ||
| + | [[Category:Set_Commands|LOCKWAIT]] | ||
| + | [[Category:Environment]] | ||
| + | [[Category:Environment Set Commands]] | ||
Latest revision as of 16:10, 23 November 2009
Purpose
Enable or disable automatic record locking
Syntax
SET LOCK ON | OFF | (<expL>)
SET LOCKWAIT ON | OFF | (<expL>)
See Also
FLOCK(), LOCK(), LOCKF, LOCKR, RLOCK(), UNLOCK
Description
The SET LOCKWAIT command determines locking behavior when you attempt to gain UPDATE access to a record which is already locked by another user. This command is only effective with shared tables. With SET LOCKWAIT ON, commands such as REPLACE will wait until a lock can be obtained. With SET LOCKWAIT OFF, an error will be generated, telling you that the operation cannot take place as the ’Record is in use by another user’. In the forms system, both settings give you the opportunity to either wait for the record to be unlocked by the other user and your lock to be granted, or, to access the record in QUERY mode. To switch from ’Query’ mode to ’Update’ mode in a form, press the [UPDATE MODE] key. By default, LOCKWAIT is ON.
Example
use patrons index events, dates, names set filter to event = "HAMLET" browse
Products
Recital Server, Recital
