Lock Record Property
Description
Specifies that Oracle Forms should attempt to lock the row in the database that corresponds to the current record in the block whenever the text item's value is modified, either by the end user or programmatically.
Applies to text item
Set Oracle Forms, programmatically
Refer to Built-in
GET_ITEM_PROPERTY
SET_ITEM_PROPERTY
No
Usage Notes
- Set this property to Yes when the text item is a control item (an item not
associated with a base table column), but you still want Oracle Forms to
lock the row in the database that corresponds to the current record in the
block.
- Useful for lookup text items where locking underlying record is required.
- To set the Lock Record property with SET_ITEM_PROPERTY, use the constant
LOCK_RECORD_ON_CHANGE.
Lock Record Restrictions
- Valid only when the item is a control item (Base Table Item property set
to No) in a data block.