A script-enabled browser is required for this page to function properly.

Insert Allowed (Item) Property

Description

Determines whether an end user can modify the value of an item in a new record (i.e., when the Record_Status is NEW or INSERT).

If you set Insert Allowed to No for an item, the user will not be able to manipulate the item in a new record. For example, the user will not be able to type into a text item, check a check box, or select a radio button.

Applies to text item, check box, list item, radio button, image item, custom items

Set Oracle Forms, programmatically

Refer to Built-in

GET_ITEM_INSTANCE_PROPERTY

GET_ITEM_PROPERTY

SET_ITEM_INSTANCE_PROPERTY

SET_ITEM_PROPERTY

Default

Yes

Usage Notes

Set Insert Allowed to No when you want the user to be able to inspect an item without being able to modify it. For example, for a system-generated key field, you might set Insert Allowed to No to prevent modification of the key while still displaying it normally (not grayed out).

Set the Enabled property to No if you want to prevent an item from responding to mouse events. Disabled items are grayed out to emphasize the fact that they are not currently applicable, while enabled items with Insert Allowed set to No allow the user to browse an item's value with the mouse or keyboard, but not to modify the item's value.

Insert Allowed resembles Update Allowed, which applies to records with a Record_Status of QUERY or CHANGED. For items in database blocks, Insert Allowed, in combination with Update Allowed, lets you control whether the end user can enter or change the value displayed by an item. For items in non-database blocks, setting Insert Allowed to No lets you create a display-only item without disabling it.

If Enabled or Visible is set to No (or PROPERTY_FALSE for runtime), then the items’ or item instance’s Insert Allowed property is effectively false.

Insert Allowed (Item) Restrictions