Update Allowed (Item) Property
Description
Specifies whether end users should be allowed to change the value of the base table item in a queried record. When Update Allowed is set to No, end users can navigate to the item in a queried record, but if they attempt to change its value, Oracle Forms displays error FRM-40200: Field is protected against update.
Setting Update Allowed to Yes does not prevent end users from entering values in a NEW (INSERT) record.
Applies to all items except buttons, chart items, and image items
Set Oracle Forms, programmatically
Refer to Built-in
GET ITEM INSTANCE PROPERTY
GET ITEM PROPERTY
SET ITEM INSTANCE PROPERTY
SET ITEM PROPERTY
Yes
Usage Notes
- To set the Update Allowed (Item) property programmatically, you can use
the constant UPDATE ALLOWED or UPDATEABLE. The constant UPDATEABLE is for
compatibility with prior releases.
- If Enabled is set to PROPERTY FALSE at runtime, then the items’ or item
instance’s Update Allowed property is also set to PROPERTY FALSE.
- When Update Allowed is specified at multiple levels (item instance, item,
and block), the values are ANDed together. This means that setting Update
Allowed to Yes (PROPERTY TRUE for runtime) has no effect at the item instance
level unless it is set consistently at the block and item levels. For example,
your user cannot update an item instance if Update Allowed is true at the
instance level, but not at the item or block levels.
Update Allowed (Item) Restrictions
- If you are using SET ITEM PROPERTY to set UPDATE ALLOWED to true, then you
must set item properties as follows:
- Enabled to Yes (PROPERTY TRUE for runtime)
- Visible to Yes (PROPERTY TRUE for runtime)
- Base Table Item to Yes (PROPERTY TRUE for runtime)
- Update Only If Null to No (PROPERTY FALSE for runtime)