dels exists.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_Komplektuechi AFTER UPDATE ON Komplektuechi for each row
- ERwin Builtin Trigger
- UPDATE trigger on KomplektuechiNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Komplektuechi Models on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "0002b5fc", PARENT_OWNER = "", PARENT_TABLE = "Komplektuechi" _OWNER = "", CHILD_TABLE = "Models"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_2", */p align="justify"> IF
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.kod_firm <>: new.kod_firm OR
: old.kod_models <>: new.kod_models OR
: old.kod_komplektuechego <>: new.kod_komplektuechego OR
: old.kod_obladnenya <>: new.kod_obladnenya
THENcount (*) 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 update Komplektuechi because Models exists.'
); IF; IF;
/* ERwin Builtin Trigger */
/* Obladnenya Komplektuechi on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", 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 update Komplektuechi because Obladnenya does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tI_Koristyvach BEFORE INSERT ON Koristyvach for each row
- ERwin Builtin Trigger
- INSERT trigger on KoristyvachNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Korzina Koristyvach on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "0000e9b6", PARENT_OWNER = "", PARENT_TABLE = "Korzina" _OWNER = "", CHILD_TABLE = "Koristyvach"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE ...
