Oracle Forms

Triggers or Event Handlers

      Exits the current form and enters the indicated form. The calling form is terminated as the parent form. If the calling form had been called by a higher form, Form Builder keeps the higher call active and treats it as a call to the new form. Form Builder releases memory (such as database cursors) that the terminated form was using.

Active X triggers:

  • On-Dispatch-Event

Block processing triggers:

  • When-Clear-Block
  •       Fires just before Form Builder clear the data from the current block.Note that the When-Clear-Block trigger does not fire when Form Builder clears the current block during the CLEAR_FORM event.

  • When-Create-Record
  •       Fires when Form Builder creates a new record. For example, when the operator presses the [Insert] key, or navigates to the last record in a set while scrolling down, Form Builder fires this trigger.

  • When-Database-Record
  •       Fires when Form Builder first marks a record as an insert or an update. That is, the trigger fires as soon as Form Builder determines through validation that the record should be processed by the next post or commit as an insert or update. This generally occurs only when the operator modifies the first item in a record, and after the operator attempts to navigate out of the item.

  • When-Remove-Record
  •       Fires whenever the operator or the application clears or deletes a record.

Interface Event triggers:

  • When-Button-Pressed
  • When-Checkbox-Changed
  • When-Custom-Item-Event
  • When-Image-Activated
  • When-List-Activated
  • When-List-Changed
  • When-Mouse-Click
  • When-Mouse-DoubleClick
  • When-Mouse-Down
  • When-Mouse-Enter
  • When-Mouse-Leave
  • When-Mouse-Move
  • When-Mouse-Up
  • When-Radio-Changed
  • When-Timer-Expired
  • When-Window-Activated
  • When-Window-Closed
  • When-Window-Deactivated
  • When-Window-Resized

Key triggers:

  • Key-Fn
  • Key-Others
  •       A Key-Others trigger fires when an operator presses the associated key.
          A Key-Others trigger overrides the default behavior of a Runform function key

Master-Detail triggers:

  • On-Check-Delete-Master
  •       Form Builder creates this trigger automatically when you define a master/detail relation and set the Delete Record Behavior property to Non-Isolated. It fires when there is an attempt to delete a record in the master block of a master/detail relation.

  • On-Clear-Details
  •       Fires when a coordination-causing event occurs in a block that is a master block in a Master/Detail relation. A coordination-causing event is any event that makes a different record the current record in the master block.

  • On-Populate-Details
  •       Form Builder creates this trigger automatically when a Master/Detail relation is defined. It fires when Form Builder would normally need to populate the detail block in a Master/Detail relation.

Message-Handling triggers:

  • On-Error
  •       An On-Error trigger fires whenever Form Builder would normally cause an error message to display.

  • On-Message
  •       Fires whenever Form Builder would normally cause a message to display and pre-empts the message.

Mouse Event triggers:

  • When-Custom-Item-Event
  • When-Mouse-Click
  • When-Mouse-DoubleClick
  • When-Mouse-Down
  • When-Mouse-Enter
  • When-Mouse-Leave
  • When-Mouse-Move
  • When-Mouse-Up

Navigation triggers:

  • Post-Block
  • Post-Form
  • Post-Record
  • Post-Text-Item
  • Pre-Block
  • Pre-Form
  • Pre-Record
  • Pre-Text-Item
  • User-Named
  • When-New-Block-Instance
  • When-New-Form-Instance
  • When-New-Item-Instance
  • When-New-Record-Instance

On triggers:

  • On-Check-Delete-Master
  • On-Check-Unique
  • On-Clear-Details
  • On-Close
  • On-Column-Security
  • On-Commit
  • On-Count
  • On-Delete
  • On-Dispatch-Event
  • On-Error
  • On-Fetch
  • On-Insert
  • On-Lock
  • On-Logon
  • On-Logout
  • On-Message
  • On-Populate-Details
  • On-Rollback
  • On-Savepoint
  • On-Select
  • On-Sequence-Number
  • On-Update

Post triggers:

  • Post-Block
  • Post-Change
  • Post-Database-Commit
  • Post-Delete
  • Post-Form
  • Post-Forms-Commit
  • Post-Insert
  • Post-Logon
  • Post-Logout
  • Post-Query
  • Post-Record
  • Post-Select
  • Post-Text-Item
  • Post-Update

Pre triggers:

  • Pre-Block
  • Pre-Commit
  • Pre-Delete
  • Pre-Form
  • Pre-Insert
  • Pre-Logon
  • Pre-Logout
  • Pre-Popup-Menu
  • Pre-Query
  • Pre-Record
  • Pre-Select
  • Pre-Text-Item
  • Pre-Update

Query-Time triggers:

  • Post-Query
  • Pre-Query

Stored Procedure triggers:

  • Delete-Procedure
  • Insert-Procedure
  • Lock-Procedure
  • Query-Procedure
  • Update-Procedure

      Stored Procedure triggers are automatically created by Form Builder when the insert /update/delete data source is a stored procedure. This trigger is called when a insert/update/delete operation is necessary. Think of this as an ON-INSERT trigger/ON-UPDATE trigger/ON-DELETE trigger that is called by the system instead of doing default insert operations.

Transactional triggers:

  • Pre triggers
  • Post triggers
  • On triggers

Validation triggers:

  • When-Validate-Item
  • When-Validate-Record

When triggers:

  • When-Button-Pressed
  • When-Checkbox-Changed
  • When-Clear-Block
  • When-Create-Record
  • When-Custom-Item-Event
  • When-Database-Record
  • When-Form-Navigate
  • When-Image-Activated
  • When-Image-Pressed
  • When-List-Activated
  • When-List-Changed
  • When-Mouse-Click
  • When-Mouse-DoubleClick
  • When-Mouse-Down
  • When-Mouse-Enter
  • When-Mouse-Leave
  • When-Mouse-Move
  • When-Mouse-Up
  • When-New-Block-Instance
  • When-New-Form-Instance
  • When-New-Item-Instance
  • When-New-Record-Instance
  • When-Radio-Changed
  • When-Remove-Record
  • When-Tab-Page-Changed
  • When-Timer-Expired
  • When-Validate-Item
  • When-Validate-Record
  • When-Window-Activated
  • When-Window-Closed
  • When-Window-Deactivated
  • When-Window-Resized

                                                                                                                             Previous     Next