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

Query-Time Triggers

Query-time triggers fire just before and just after the operator or the application executes a query in a block.

Trigger

Typical Usage

Pre-Query

Validate the current query criteria or provide additional query criteria programmatically, just before sending the SELECT statement to the database.

Post-Query

Perform an action after fetching a record, such as looking up values in other tables based on a value in the current record. Fires once for each record fetched into the block.

 


Creating a trigger in the Object Navigator

Block processing triggers

Interface event triggers

Master/Detail triggers

Message-handling triggers

Navigational triggers

Transactional triggers

Validation triggers

Other trigger categories