">: 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 insert Firm because Shogi_tovary does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_Firm AFTER UPDATE ON Firm for each row
- ERwin Builtin Trigger
- UPDATE trigger on FirmNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Models Firm on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "0003a835", PARENT_OWNER = "", PARENT_TABLE = "Models" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_1", */p align="justify"> SELECT count (*) INTO NUMROWSModels
/*% JoinFKPK (:% New, Models, "=", "AND") */
: new.kod_modeli = Models.kod_modely AND
: new.kod_firm = Models.kod_firm AND
: new.kod_komplektuechego = Models.kod_komplektuechgo AND
: new.kod_obladnya = Models.kod_obladnya; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Firm because Models does not exist.'
); IF;
/* ERwin Builtin Trigger */
/* Koristyvach Firm on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Koristyvach" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_5", FK_COLUMNS = "name" "familia" "kod_firm" */count (*) INTO NUMROWSKoristyvach
/*% JoinFKPK (:% New, Koristyvach, "=", "AND") */
: new.name = Koristyvach.Name AND
: new.familia = Koristyvach.Familia AND
: new.kod_firm = Koristyvach.kod_firn; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Firm because Koristyvach does not exist.'
); IF;
/* ERwin Builtin Trigger */
/* Shogi_tovary Firm on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Shogi_tovary" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PH...
