RASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_7", FK_COLUMNS = "name_firm" "kod_firm" "kod_tovary" "name_models" */count (*) INTO NUMROWSShogi_tovary
/*% JoinFKPK (:% New, Shogi_tovary, "=", "AND") */
: new.name_firm = Shogi_tovary.Name_Firm AND
: new.kod_firm = Shogi_tovary.kod_firm AND
: new.kod_tovary = Shogi_tovary.kod_tovary AND
: new.name_models = Shogi_tovary.Name_models; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Firm because Shogi_tovary does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tI_Komplektuechi BEFORE INSERT ON Komplektuechi for each row
- ERwin Builtin Trigger
- INSERT trigger on KomplektuechiNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Obladnenya Komplektuechi on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "000104c6", PARENT_OWNER = "", PARENT_TABLE = "Obladnenya" _OWNER = "", CHILD_TABLE = "Komplektuechi"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_3", FK_COLUMNS = "kod_obladnenya" */
SELECT count (*) INTO NUMROWSObladnenya
/*% JoinFKPK (:% New, Obladnenya, "=", "AND") */
: new.kod_obladnenya = Obladnenya.kod_obladnenya; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot insert Komplektuechi because Obladnenya does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tD_Komplektuechi AFTER DELETE ON Komplektuechi for each row
- ERwin Builtin Trigger
- DELETE trigger on KomplektuechiNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Komplektuechi Models on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "000124b7", PARENT_OWNER = "", PARENT_TABLE = "Komplektuechi" _OWNER = "", CHILD_TABLE = "Models"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_2", */p align="justify"> SELECT count (*) INTO NUMROWSModels
/*% JoinFKPK (Models,:% Old, "=", "AND") * /. kod_firm =: old.kod_firm AND.kod_modely =: old.kod_models AND.kod_komplektuechgo =: old.kod_komplektuechego AND.kod_obladnya =: old.kod_obladnenya; (NUMROWS> 0) _application_error (
,
'Cannot delete Komplektuechi because Mo...
