Corrective Table Constraints: When Evaluated

Previous Next

See Also

The Rules Engine validates corrective single-record constraints at record validation time, when the record is stored. Corrective single-record constraints are validated before restrictive single-record constraints on the same record.

Simultaneously, corrective multi-record transitional constraints for which the updated table is the triggering table are evaluated at the same time. These constraints are called Update On Self constraints.

Corrective multi-record non-transitional constraints are also evaluated at record validation time. If the table they potentially update is the same as the table currently manipulated, they are evaluated before restrictive single-record constraints, otherwise they are evaluated after.