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

Pre-Record Trigger

Description

Fires during the Enter the Record process, during navigation to a different record.

Definition Level form or block

Legal Commands

SELECT statements, unrestricted Built-ins

Enter Query Mode no

Usage Notes

Use a Pre-Record trigger to keep a running total.

On Failure

Navigation fails and focus remains in the current item.

Fires In

Enter the Record

Pre-Record Trigger Restrictions

A Pre-Record trigger fires only when the form is run with a validation unit of the item or record, as specified by the Validation Unit form property.

Pre-Record Trigger Example

The following trigger prevents the user from entering a new record given some dynamic condition and the status of SYSTEM.RECORD_STATUS evaluating to NEW.

IF (( dynamic-condition)
AND :System.Record_Status = 'NEW') THEN
RAISE Form_Trigger_Failure;
END IF;