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

About Controlling Inserts

Set the Insert Allowed block property to specify whether a block should support inserting new records in its base table. When Insert Allowed is set to Yes (the default), the Insert Allowed item property determines whether each individual item in the block supports inserting new records.

Specifically, the Insert Allowed item property determines whether operators can modify the value of an item in a new record (i.e., when the status of the record is NEW or INSERT).

When the Insert Allowed item property is set to No, and the item has the Keyboard Navigable and/or Enabled properties set to Yes, operators can navigate to the item, but cannot modify its value when it is in a new record.

When a block supports inserting new records, Oracle Forms creates a new record in the block when any of the following events occur:


Related topics

About default values for items in new records

About item hint text