Reparations

See Also

Reparations are corrective constraints that are executed at record validation time, after the storage of the record. Corrective constraints are handled as reparations if they may update a record in a different table to the table in which the current row event takes place. This is the case if the triggering table is different to the updated table (See "Tables in Constraints").

Constraints that update other records in the same table are also handled as reparations, because these constraints cannot be handled as Update On Self. Although the triggering table is the updated table, there are different occurrences or instances of that table within the constraint text.

Corrective multi-record constraints are thus either Update On Self constraints and are handled pre-store, or they are reparations and are handled post-store.