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

Triggers Comparison

A comparison of these triggers follows :

Post-Forms-Commit vs. Post-Database-Commit

POST-FORMS-COMMIT fires as the last trigger which is still part of the current transaction during commit-time processing. It is the last chance for the application to perform any processing or to rollback the transaction before the actual 'COMMIT' is issued.

The POST-DATABASE-COMMIT triggers fires just after the 'COMMIT' statement is issued by forms to close the current transaction. At this point it is too late to rollback the transaction.

Pre-Query vs. Pre-Select

PRE-QUERY fires just before Forms begins to prepare the SQL statement that will be required to query the appropriate records from the database in response to the query criteria that have been entered into the example record.

It is the designer’s last chance to "deposit" query criteria into the items in the block as if they had been entered into the example record by the operator.

PRE-SELECT fires after the PRE-QUERY trigger, and just before the actual, physical construction of the SELECT statement begins. It would typically be used in conjunction with an ON-SELECT trigger in which the designer would be supplanting the normal construction of the SELECT statement with a user exit of his own to construct and prepare the SELECT statement for execution (perhaps against a foreign datasource).