LD_TABLE = "Warehouse" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_1", FK_COLUMNS = "ID_store" */count (*) INTO NUMROWSInternet_store
/*% JoinFKPK (:% New, Internet_store, "=", "AND") */
: new.ID_store = Internet_store.ID_store; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot insert Warehouse because Internet_store does not exist.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tD_Warehouse AFTER DELETE ON Warehouse for each row
- ERwin Builtin Trigger
- DELETE trigger on WarehouseNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Warehouse Good on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0000ca01", PARENT_OWNER = "", PARENT_TABLE = "Warehouse" _OWNER = "", CHILD_TABLE = "Good" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_2", FK_COLUMNS = "ID_warehouse" */count (*) INTO NUMROWSGood
/* % JoinFKPK (Good,:% Old, "=", "AND") * /. ID_warehouse =: old.ID_warehouse; (NUMROWS> 0) _application_error (
,
'Cannot delete Warehouse because Good exists.'
); IF;
- ERwin Builtin Trigger;
/ TRIGGER tU_Warehouse AFTER UPDATE ON Warehouse for each row
- ERwin Builtin Trigger
- UPDATE trigger on WarehouseNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Warehouse Good on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "00020a7b", PARENT_OWNER = "", PARENT_TABLE = "Warehouse" _OWNER = "", CHILD_TABLE = "Good" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_2", FK_COLUMNS = "ID_warehouse" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.ID_warehouse <>: new.ID_warehousecount (*) INTO NUMROWSGood
/* % JoinFKPK (Good,:% Old, "=", "AND") * /. ID_warehouse =: old.ID_warehouse; (NUMROWS> 0) _application_error (
,
'Cannot update Warehouse because Good exists.'
); IF; IF;
/...
