old.kod_komplektuechgo <>: new.kod_komplektuechgo OR
: old.kod_obladnya <>: new.kod_obladnya
THENcount (*) 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 update Models because Firm exists.'
); IF; IF;
/* ERwin Builtin Trigger */
/* Komplektuechi Models on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", 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 update Models because Komplektuechi does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tD_News AFTER DELETE ON News for each row
- ERwin Builtin Trigger
- DELETE trigger on NewsNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* News Shogi_tovary on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0000f5bf", PARENT_OWNER = "", PARENT_TABLE = "News" _OWNER = "", CHILD_TABLE = "Shogi_tovary"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_6", FK_COLUMNS = "Name_Firm" "Name_models" */count (*) INTO NUMROWSShogi_tovary
/*% JoinFKPK (Shogi_tovary,:% Old, "=", "AND") */_tovary.Name_Firm =: old.Name_firm AND_tovary.Name_models =: old.Name_models; ( NUMROWS> 0) _application_error (
,
'Cannot delete News because Shogi_tovary exists.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_News AFTER UPDATE ON News for each row
- ERwin Builtin Trigger
- UPDATE trigger on NewsNUMROWS INTEGER;
/* ER...
