PARENT_OWNER = "", PARENT_TABLE = "Korzina" _OWNER = "", CHILD_TABLE = "Koristyvach"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_4", FK_COLUMNS = "kod_firn" */count (*) INTO NUMROWSKorzina
/*% JoinFKPK (:% New, Korzina, "=", "AND") */
: new.kod_firn = Korzina.kod_firm; (
/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0
) _application_error (
,
'Cannot update Koristyvach because Korzina does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tD_Korzina AFTER DELETE ON Korzina for each row
- ERwin Builtin Trigger
- DELETE trigger on KorzinaNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Korzina Koristyvach on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0000d7be", PARENT_OWNER = "", PARENT_TABLE = "Korzina" _OWNER = "", CHILD_TABLE = "Koristyvach"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_4", FK_COLUMNS = "kod_firn" */count (*) INTO NUMROWSKoristyvach
/*% JoinFKPK (Koristyvach,:% Old, "=", "AND") * /. kod_firn =: old.kod_firm; (NUMROWS> 0) _application_error (
,
'Cannot delete Korzina because Koristyvach exists.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_Korzina AFTER UPDATE ON Korzina for each row
- ERwin Builtin Trigger
- UPDATE trigger on KorzinaNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Korzina Koristyvach on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "0001065b", PARENT_OWNER = "", PARENT_TABLE = "Korzina" _OWNER = "", CHILD_TABLE = "Koristyvach"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_4", FK_COLUMNS = "kod_firn" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.kod_firm <>: new.kod_firmcount (*) INTO NUMROWSKoristyvach
/*% JoinFKPK (Koristyvach,:% Old, "=", "AND") * /. kod_firn =: old.kod_firm; (NUMROWS> 0) _application_error (
,
'Cannot update Korzina because Koristyvach exists.'
); IF; IF;
- ERwin Builtin Trigger;
/TRIGGER tI_Models BEFORE INSERT ON Models for each row
- ERwin Builtin Trigger
- INSERT trigger on ModelsNUMROWS INTEGER;
