="justify">/* ERwin Builtin Trigger */
/* Deliverer Delivery on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Deliverer" _OWNER = "", CHILD_TABLE = "Delivery" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_6", FK_COLUMNS = "Ow_comp" */count (*) INTO NUMROWSDeliverer
/*% JoinFKPK (:% New, Deliverer, "=", "AND") */
: new.Ow_comp = Deliverer.Ow_comp; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Delivery because Deliverer does not exist.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tI_Good BEFORE INSERT ON Good for each row
- ERwin Builtin Trigger
- INSERT trigger on GoodNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Warehouse Good on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "0000ef47", PARENT_OWNER = "", PARENT_TABLE = "Warehouse" _OWNER = "", CHILD_TABLE = "Good" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_2", FK_COLUMNS = "ID_warehouse" */count (*) INTO NUMROWSWarehouse
/*% JoinFKPK (:% New, Warehouse, "=", "AND") */
: new.ID_warehouse = Warehouse.ID_warehouse; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot insert Good because Warehouse does not exist.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tD_Good AFTER DELETE ON Good for each row
- ERwin Builtin Trigger
- DELETE trigger on GoodNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Good Delivery on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "00056dc4", PARENT_OWNER = "", PARENT_TABLE = "Good" _OWNER = "", CHILD_TABLE = "Delivery" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_3", FK_COLUMNS = "ID_good" */count (*) INTO NUMROWSDelivery
/* % JoinFKPK (Delivery,:% Old, "=", "AND") * /. ID_good =: old.ID_good; (NUMROWS> 0) _application_...
