Sunday, July 10, 2016

Firing Sequence Of Form triggers


Introduction
This document lists the order in which triggers fire in Oracle Forms 4.5:

  • The first column, Action, describes the function to be performed (e.g. deleting a record).
  • The second column, Trigger Firing Order, describes the order in which triggers fire after a function is performed.
  • The third column, Level, describes the level (form, block, item) at which the trigger fires. This was accomplished by creating a form with all the triggers invoked. If a trigger could fire at all levels, it was included at all levels. Such a trigger fires at the lowest level at which it is defined.
Key triggers and triggers which fire via buttons or check boxes are not included.
RunformPre-LogonForm

On-LogonForm

Post-LogonForm

Pre-FormForm

When-Create-RecordBlock

Pre-BlockBlock

Pre-RecordBlock

Pre-Text-ItemItem

When-New-Form-InstanceForm

When-New-Block-InstanceBlock

When-New-Record-InstanceBlock

When-New-Item-InstanceItem



Enter QueryPost-Text-ItemItem

Post-RecordBlock

When-Clear-BlockBlock

When-New-Record-InstanceBlock

When-New-Item-InstanceItem



Execute Query After Enter QueryPre-QueryBlock

Pre-SelectBlock

On-SelectBlock

When-Clear-BlockBlock

Post-SelectBlock

On-FetchBlock

On-CloseForm

When-Clear-BlockBlock



Execute Query Without Enter QueryPost-Text-ItemBlock

Pre-QueryBlock

Pre-SelectBlock

On-SelectBlock

Post-SelectBlock

On-FetchBlock

On-CloseForm

When_Create_RecordBlock

Pre-RecordBlock

Pre-Text-ItemItem

When-New-Record-InstanceBlock

When-New-Item-InstanceItem



ExitPost-Text-ItemItem

Post-RecordBlock

Post-BlockBlock

Post-FormForm

On-RollbackForm

Pre-LogoutForm

On-LogoutForm

Post-LogoutForm



Next Block and Previous BlockPost-Text-ItemItem

Post-RecordBlock

Post-BlockBlock

When-Create-RecordBlock

Pre-BlockBlock

Pre-RecordBlock

Pre-Text-ItemBlock

When-New-Block-InstanceBlock

When-New-Record-InstanceBlock

When-New-Item-InstanceForm



Create RecordPost-ChangeBlock

When-Validate-ItemBlock

Post-Text-ItemBlock

When-Validate-RecordBlock

Post-RecordBlock

Post-BlockBlock

On-SavepointForm

Pre-CommitForm

Pre-InsertBlock

On-InsertForm

Post-InsertBlock

Post-Forms-CommitForm

On-CommitForm

Post-Database-CommitForm

Pre-BlockBlock

Pre-RecordBlock

Pre-Text-ItemBlock

When-New-Item-InstanceForm



Update RecordWhen-Database-RecordBlock

Post-ChangeBlock

When-Validate-ItemBlock

Post-Text-ItemBlock

When-Validate-RecordBlock

Post-RecordBlock

Post-BlockBlock

On-SavepointForm

Pre-CommitForm

Pre-UpdateBlock

On-UpdateBlock

Post-UpdateBlock

Post-Forms-CommitForm

On-CommitForm

Post-Database-CommitForm

Pre-Text-ItemBlock

When-New-Item-InstanceForm



Delete RecordOn-LockBlock

When-Remove-RecordBlock

Post-ChangeBlock

Post-ChangeBlock

Post-ChangeBlock

Post-ChangeBlock

Post-ChangeBlock

Post-ChangeBlock

Post-ChangeItem

Post-QueryBlock

Post-Text-ItemBlock

Post-RecordBlock

Pre-RecordBlock

Pre-Text-ItemBlock

When-New-Record-InstanceBlock

When-New-Item-InstanceForm

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...