= "",
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 insert Koristyvach because Korzina does not exist.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tD_Koristyvach AFTER DELETE ON Koristyvach for each row
- ERwin Builtin Trigger
- DELETE trigger on KoristyvachNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Koristyvach Firm on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = "0000ec92", PARENT_OWNER = "", PARENT_TABLE = "Koristyvach" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_5", FK_COLUMNS = "name" "familia" "kod_firm" */count (*) INTO NUMROWSFirm
/*% JoinFKPK (Firm,:% Old, "=", "AND") * /. name =: old.Name AND.familia =: old.Familia AND.kod_firm =: old.kod_firn; (NUMROWS> 0) _application_error (
,
'Cannot delete Koristyvach because Firm exists.'
); IF;
- ERwin Builtin Trigger;
/TRIGGER tU_Koristyvach AFTER UPDATE ON Koristyvach for each row
- ERwin Builtin Trigger
- UPDATE trigger on KoristyvachNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Koristyvach Firm on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = "00023bc0", PARENT_OWNER = "", PARENT_TABLE = "Koristyvach" _OWNER = "", CHILD_TABLE = "Firm"
P2C_VERB_PHRASE = "", C2P_VERB_PHRASE = "",
FK_CONSTRAINT = "R_5", FK_COLUMNS = "name" "familia" "kod_firm" */
/*% JoinPKPK (:% Old,:% New, "<>", "OR") */
: old.Name <>: new.Name OR
: old.Familia <>: new.Familia OR
: old.kod_firn <>: new.kod_firncount (*) INTO NUMROWSFirm
/*% JoinFKPK (Firm,:% Old, "=", "AND") * /. name =: old.Name AND.familia =: old.Familia AND.kod_firm =: old.kod_firn; (NUMROWS> 0) _application_error (
,
'Cannot update Koristyvach because Firm exists.'
); IF; IF;
/* ERwin Builtin Trigger */
/* Korzina Koristyvach on child update restrict */
/* ERWIN_RELATION: CHECKSUM = "00000000", ...
