AND_del.Summ =: old.Summ AND_del.N_S_ord =: old.N_S_ord AND_del.Delivery =: old.Delivery; (NUMROWS> 0) _application_error (
,
'Cannot update Ord because Ord_del exists.'
); IF; IF;
/* ERwin Builtin Trigger */
/* Good Ord on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Good" _OWNER = "", CHILD_TABLE = "Ord" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_4", FK_COLUMNS = "ID_good" */count (*) INTO NUMROWSGood
/*% JoinFKPK (:% New, Good, "=", "AND") */
: new.ID_good = Good.ID_good; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Ord because Good does not exist.'
); IF;
/* ERwin Builtin Trigger */
/* Orderer Ord on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Orderer" _OWNER = "", CHILD_TABLE = "Ord" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_5", FK_COLUMNS = "N_S_ord" */count (*) INTO NUMROWSOrderer
/*% JoinFKPK (:% New, Orderer, "=", "AND") */
: new.N_S_ord = Orderer.N_S_ord; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Ord because Orderer does not exist.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tI_Ord_del BEFORE INSERT ON Ord_del for each row
- ERwin Builtin Trigger
- INSERT trigger on Ord_delNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Ord Ord_del on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "000246d2", PARENT_OWNER = "", PARENT_TABLE = "Ord" _OWNER = "", CHILD_TABLE = "Ord_del" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_7", FK_COLUMNS = "ID_ordering" "Summ" "N_S_ord" "Delivery" */count (*) INTO NUMROWSOrd
/*% JoinFKPK (:% New, Ord, "=", "AND") */
: new.ID_ordering = Ord.ID_ordering AND
: new.Summ = Ord.Summ AND
: new.N_S_ord = Ord.N_S_ord AND
: new.Delivery = Ord.Delivery; (
