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:
- The operator selects Record | Insert from the
default form menu.
- The application executes the CREATE_RECORD
Built-in procedure.
- The operator or the application navigates to the next record when the focus
is in the last record in the block. For example, if the focus is in the last
record in a block and the operator presses [Next Record], Oracle Forms
creates a new record in the block.
- Oracle Forms also creates a new record in a block the first time the
block is visited during a session. For example, at form startup, when Oracle Forms navigates to the first navigable item in the first block in the
form, a new record is created in that block. The status of a record changes
from NEW to INSERT as soon as the operator enters data that would need to
be committed to the database by the next Save/Commit operation.
Related topics
About default values for items in new records
About item hint text