n="justify">/* ERwin Builtin Trigger */
/* Komplektuechi Models on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "00015c81", PARENT_OWNER = "", PARENT_TABLE = "Komplektuechi" _OWNER = "", CHILD_TABLE = "Models"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_2", */p align="justify"> SELECT count (*) INTO NUMROWSKomplektuechi
/*% JoinFKPK (:% New, Komplektuechi, "=", "AND") */
: new.kod_firm = Komplektuechi.kod_firm AND
: new.kod_modely = Komplektuechi.kod_models AND
: new.kod_komplektuechgo = Komplektuechi.kod_komplektuechego AND
: new.kod_obladnya = Komplektuechi.kod_obladnenya; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot insert Models because Komplektuechi does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tD_Models AFTER DELETE ON Models for each row
- ERwin Builtin Trigger
- DELETE trigger on ModelsNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Models Firm on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "00012069", PARENT_OWNER = "", PARENT_TABLE = "Models" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_1", */p align="justify"> SELECT count (*) INTO NUMROWSFirm
/*% JoinFKPK (Firm,:% Old, "=", "AND") * /. kod_modeli =: old.kod_modely AND.kod_firm =: old.kod_firm AND
Firm.kod_komplektuechego =: old.kod_komplektuechgo AND.kod_obladnya =: old.kod_obladnya;
IF (NUMROWS> 0) _application_error (
,
'Cannot delete Models because Firm exists.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_Models AFTER UPDATE ON Models for each row
- ERwin Builtin Trigger
- UPDATE trigger on ModelsNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Models Firm on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "0002e12e", PARENT_OWNER = "", PARENT_TABLE = "Models" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_1", */p align="justify"> IF
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.kod_modely <>: new.kod_modely OR
: old.kod_firm <>: new.kod_firm OR
: ...
