win Builtin Trigger */
/* News Shogi_tovary on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "00012959", 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" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.Name_firm <>: new.Name_firm OR
: old.Name_models <>: new.Name_modelscount (*) 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 update News because Shogi_tovary exists.'
); IF; IF;
- ERwin Builtin Trigger;
/TRIGGER tD_Obladnenya AFTER DELETE ON Obladnenya for each row
- ERwin Builtin Trigger
- DELETE trigger on ObladnenyaNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Obladnenya Komplektuechi on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0000f377", 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 NUMROWSKomplektuechi
/*% JoinFKPK (Komplektuechi,:% Old, "=", "AND") * /. kod_obladnenya =: old.kod_obladnenya; (NUMROWS> 0) _application_error (
,
'Cannot delete Obladnenya because Komplektuechi exists.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_Obladnenya AFTER UPDATE ON Obladnenya for each row
- ERwin Builtin Trigger
- UPDATE trigger on ObladnenyaNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Obladnenya Komplektuechi on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "00011a77", PARENT_OWNER = "", PARENT_TABLE = "Obladnenya" _OWNER = "", CHILD_TABLE = "Komplektuechi"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "", _CONSTRAINT = "R_3", FK_COLUMNS = "kod_obladnenya" */
IF
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.kod_obladnenya <>: new.kod_obladnenyacount (*) INTO NUMROWSKomplektuechi
/*% JoinFKPK (Komplektuechi,:% Old, "=", "AND") * /. kod_obladnenya =: old.kod_obladnenya; (NUMROWS> 0) _application_error (...
