="justify">/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot insert Ord_del because Ord does not exist.'
); IF;
/* ERwin Builtin Trigger */
/* Courier Ord_del on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Courier" _OWNER = "", CHILD_TABLE = "Ord_del" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_8", FK_COLUMNS = "N_S_cour" "Phone_cour" "ID_courier" */count (*) INTO NUMROWSCourier
/*% JoinFKPK (:% New, Courier, "=", "AND") */
: new.ID_courier = Courier.ID_courier AND
: new.N_S_cour = Courier.N_S_cour AND
: new.Phone_cour = Courier.Phone_cour; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot insert Ord_del because Courier does not exist.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tU_Ord_del AFTER UPDATE ON Ord_del for each row
- ERwin Builtin Trigger
- UPDATE trigger on Ord_delNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Ord Ord_del on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "000239d1", 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; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Ord_del because Ord does not exist.'
); IF;
/* ERwin Builtin Trigger */
/* Courier Ord_del on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Courier" _OWNER = "", CHILD_TABLE = "Ord_del" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_8", FK_COLUMNS = "N_S_cou...
