E = "Warehouse" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_1", FK_COLUMNS = "ID_store" */count (*) INTO NUMROWSWarehouse
/* % JoinFKPK (Warehouse,:% Old, "=", "AND") * /. ID_store =: old.ID_store; (NUMROWS> 0) _application_error (
,
'Cannot delete Internet_store because Warehouse exists.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tU_Internet_store AFTER UPDATE ON Internet_store for each row
- ERwin Builtin Trigger
- UPDATE trigger on Internet_storeNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Internet_store Warehouse on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "0001039e", PARENT_OWNER = "", PARENT_TABLE = "Internet_store" _OWNER = "", CHILD_TABLE = "Warehouse" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_1", FK_COLUMNS = "ID_store" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.ID_store <>: new.ID_storecount (*) INTO NUMROWSWarehouse
/* % JoinFKPK (Warehouse,:% Old, "=", "AND") * /. ID_store =: old.ID_store; (NUMROWS> 0) _application_error (
,
'Cannot update Internet_store because Warehouse exists.'
); IF; IF;
- ERwin Builtin Trigger; TRIGGER tI_Ord BEFORE INSERT ON Ord for each row
- ERwin Builtin Trigger
- INSERT trigger on OrdNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Good Ord on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "0001cbab", 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 insert Ord because Good does not exist.'
); IF;
/* ERwin Builtin Trigger */
/* Orderer Ord on child inser...
