,
'Cannot update Obladnenya because Komplektuechi exists.'
); IF; IF;
- ERwin Builtin Trigger;
/TRIGGER tI_Shogi_tovary BEFORE INSERT ON Shogi_tovary for each row
- ERwin Builtin Trigger
- INSERT trigger on Shogi_tovaryNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* News Shogi_tovary on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = "0000fd9a", 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 insert Shogi_tovary because News does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tD_Shogi_tovary AFTER DELETE ON Shogi_tovary for each row
- ERwin Builtin Trigger
- DELETE trigger on Shogi_tovaryNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Shogi_tovary Firm on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0001114b", PARENT_OWNER = "", PARENT_TABLE = "Shogi_tovary" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_7", FK_COLUMNS = "name_firm" "kod_firm" "kod_tovary" "name_models" */count (*) 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 delete Shogi_tovary because Firm exists.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_Shogi_tovary AFTER UPDATE ON Shogi_tovary for each row
- ERwin Builtin Trigger
- UPDATE trigger on Shogi_tovaryNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Shogi_tovary Firm on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "00028ee1", PARENT_OWNER = "", PARENT_TABLE = "Shogi_tovary" _OWNER = "", CHILD_TABLE = "Firm"
