Query-time triggers fire just before and just after the operator or the application executes a query in a block.
Trigger |
Typical Usage |
---|---|
Validate the current query criteria or provide additional query criteria programmatically, just before sending the SELECT statement to the database. |
|
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. |