-->

Spiga

Trigger Typical Usage On Different Levels

Trigger Typical Usage On Different Levels

A.Block Processing Triggers:

When-Create-Record: Perform an action whenever Form Builder attempts to create a new record in a block. For example, to set complex, calculated, or data-driven default values that must be specified at runtime, rather than design time.

When-Clear-Block: Perform an action whenever Form Builder flushes the current block; that is, removes all records from the block.

When-Database-Record: Perform an action whenever Form Builder changes a record's status to Insert or Update, thus indicating that the record should be processed by the next COMMIT_FORM operation

When-Remove-Record : Perform an action whenever a record is cleared or deleted. For example, to adjust a running total that is being calculated for all of the records displayed in a block.

When-New-Block-Instance: Perform an action immediately after the input focus moves to an item in a block other than the block that previously had input focus.

When-New-Record-Instance :Perform an action immediately after the input focus moves to an item in a different record. If the new record is in a different block, fires after the When-New-Block-Instance trigger, but before the When-New-Item-Instance trigger.

When-New-Item-Instance: Perform an action immediately after the input focus moves to a different item. If the new item is in a different block, fires after the When-New-Block-Instance trigger.

On-Delete: Replace the default Form Builder processing for handling deleted records during transaction posting.

On-Insert : Replace the default Form Builder processing for handling inserted records during transaction posting.

On-Lock: Replace the default Form Builder processing for locking rows in the database.

On-Logon: Replace the default Form Builder processing for connecting to ORACLE, especially for a form that does not require a database connection or for connecting to a non-ORACLE data source.

On-Logout: Replace the default Form Builder processing for logout from ORACLE.

On-Update: Replace the default Form Builder processing for handling updated records during transaction posting.

Post-Database-Commit: Augment default Form Builder processing following a database commit.

Post-Delete: Audit transactions following the deletion of a row from the database.

Post-Forms-Commit: Augment the default Form Builder commit statement prior to committing a transaction.

Post-Insert Audit transactions following the insertion of a row in the database.

Post-Update Audit: transactions following the updating of a row in the database.

Pre-Commit: Perform an action immediately before the Post and Commit Transactions process, when Form Builder determines that there are changes in the form to post or to commit.

Pre-Delete: Manipulate a record prior to its being deleted from the database during the default Post and Commit Transactions process; for example, to prevent deletion of the record if certain conditions exist.

Pre-Insert: Manipulate a record prior to its being inserted in the database during the default Post and Commit Transactions process.

Pre-Update:Validate or modify a record prior to its being updated in the database during the default Post and Commit Transactions process.

Pre-Form: Perform an action just before Form Builder navigates to the form from "outside" the form, such as at form startup.

Pre-Block :Perform an action before Form Builder navigates to the block level from the form level.

Pre-Record :Perform an action before Form Builder navigates to the record level from the block level.

Pre-Text-Item :Perform an action before Form Builder navigates to a text item from the record level.

Post-Text-Item: Manipulate an item when Form Builder leaves a text item and navigates to the record level.

Post-Record: Manipulate a record when Form Builder leaves a record and navigates to the block level.

Post-Block: Manipulate the current record when Form Builder leaves a block and navigates to the form level.

Post-Form: Perform an action before Form Builder navigates to "outside" the form, such as when exiting the form.

When-New-Form-Instance: Perform an action at form start-up. (Occurs after the Pre-Form trigger fires).

When-New-Block-Instance: Perform an action immediately after the input focus moves to an item in a block other than the block that previously had input focus.

When-New-Record-Instance :Perform an action immediately after the input focus moves to an item in a different record. If the new record is in a different block, fires after the When-New-Block-Instance trigger, but before the When-New-Item-Instance trigger.

When-New-Item-Instance: Perform an action immediately after the input focus moves to a different item. If the new item is in a different block, fires after the When-New-Block-Instance trigger.

When-Validate-Item: Augment default validation of an item.

When-Validate-Record :Augment default validation of a record.


There was an error in this gadget