ount (*) INTO NUMROWSOrd_del
/* % JoinFKPK (Ord_del,:% Old, "=", "AND") */_del.ID_courier =: old.ID_courier AND_del.N_S_cour =: old.N_S_cour AND_del.Phone_cour =: old.Phone_cour; (NUMROWS> 0) _application_error (
,
'Cannot update Courier because Ord_del exists.'
); IF; IF;
- ERwin Builtin Trigger;
/ TRIGGER tD_Deliverer AFTER DELETE ON Deliverer for each row
- ERwin Builtin Trigger
- DELETE trigger on DelivererNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Deliverer Delivery on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0000d933", PARENT_OWNER = "", PARENT_TABLE = "Deliverer" _OWNER = "", CHILD_TABLE = "Delivery" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_6", FK_COLUMNS = "Ow_comp" */count (*) INTO NUMROWSDelivery
/* % JoinFKPK (Delivery,:% Old, "=", "AND") * /. Ow_comp =: old.Ow_comp; (NUMROWS> 0) _application_error (
,
'Cannot delete Deliverer because Delivery exists.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tU_Deliverer AFTER UPDATE ON Deliverer for each row
- ERwin Builtin Trigger
- UPDATE trigger on DelivererNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Deliverer Delivery on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "0000fde4", PARENT_OWNER = "", PARENT_TABLE = "Deliverer" _OWNER = "", CHILD_TABLE = "Delivery" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_6", FK_COLUMNS = "Ow_comp" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.Company <>: new.Companycount (*) INTO NUMROWSDelivery
/* % JoinFKPK (Delivery,:% Old, "=", "AND") * /. Ow_comp =: old.Ow_comp; (NUMROWS> 0) _application_error (
,
'Cannot update Deliverer because Delivery exists.'
); IF; IF;
- ERwin Builtin Trigger;
/ TRIGGER tI_Delivery BEFO...
