fy"> P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_7", FK_COLUMNS = "name_firm" "kod_firm" "kod_tovary" "name_models" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.Name_Firm <>: new.Name_Firm OR
: old.kod_firm <>: new.kod_firm OR
: old.kod_tovary <>: new.kod_tovary OR
: old.Name_models <>: new.Name_modelscount (*) INTO NUMROWSFirm
/*% JoinFKPK (Firm,:% Old, "=", "AND") * /. name_firm =: old.Name_Firm AND.kod_firm =: old.kod_firm AND.kod_tovary =: old.kod_tovary AND.name_models =: old.Name_models; (NUMROWS> 0) _application_error (
,
'Cannot update Shogi_tovary because Firm exists.'
); IF; IF;
/* ERwin Builtin Trigger */
/* News Shogi_tovary on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", 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 NUMROWSNews
/*% JoinFKPK (:% New, News, "=", "AND") */
: new.Name_Firm = News.Name_firm AND
: new.Name_models = News.Name_models; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Shogi_tovary because News does not exist.'
); IF;
- ERwin Builtin Trigger;
/
