r" "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 update Ord_del because Courier does not exist.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tD_Orderer AFTER DELETE ON Orderer for each row
- ERwin Builtin Trigger
- DELETE trigger on OrdererNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Orderer Ord on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0000c238", 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 NUMROWSOrd
/* % JoinFKPK (Ord,:% Old, "=", "AND") * /. N_S_ord =: old.N_S_ord; (NUMROWS> 0) _application_error (
,
'Cannot delete Orderer because Ord exists.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tU_Orderer AFTER UPDATE ON Orderer for each row
- ERwin Builtin Trigger
- UPDATE trigger on OrdererNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Orderer Ord on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "0000ebc7", PARENT_OWNER = "", PARENT_TABLE = "Orderer" _OWNER = "", CHILD_TABLE = "Ord" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_5", FK_COLUMNS = "N_S_ord" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.N_S_ord <>: new.N_S_ordcount (*) INTO NUMROWSOrd
/* % JoinFKPK (Ord,:% Old, "=", "AND") * /. N_S_ord =: old.N_S_ord; (NUMROWS> 0) _application_error (
,
'Cannot update Orderer because Ord exists.'
); IF; IF;
- ERwin Builtin Trigger;
/
