Fires during the Enter the Record process, during navigation to a different record.
Definition Level form or block
SELECT statements, unrestricted Built-ins
Enter Query Mode no
Use a Pre-Record trigger to keep a running total.
Navigation fails and focus remains in the current item.
Enter the Record
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.
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;