HECKSUM = «00010666», PARENT_OWNER = »», PARENT_TABLE = «Sklad» _OWNER = »», CHILD_TABLE = «Kyrjeru» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = «R_31», FK_COLUMNS = «nom_post» «post_no» «inv_numb» */count (*) INTO NUMROWSSklad
/*% JoinFKPK (:% New, Sklad, В»=В», В»ANDВ») */
: new.nom_post = Sklad.nom_post AND
: new.post_no = Sklad.post_no AND
: new.inv_numb = Sklad.inv_numb; (
/*% NotnullFK (:% New, В»IS NOT NULL ANDВ») */= 0
) _application_error (
,
'Cannot insert Kyrjeru because Sklad does not exist.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tU_Kyrjeru AFTER UPDATE ON Kyrjeru for each row
ERwin Builtin Trigger
UPDATE trigger on KyrjeruNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Sklad Kyrjeru on child update restrict */
/* ERWIN_RELATION: CHECKSUM = «00010829», PARENT_OWNER = »», PARENT_TABLE = «Sklad» _OWNER = »», CHILD_TABLE = «Kyrjeru» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = «R_31», FK_COLUMNS = «nom_post» «post_no» «inv_numb» */count (*) INTO NUMROWSSklad
/*% JoinFKPK (:% New, Sklad, В»=В», В»ANDВ») */
: new.nom_post = Sklad.nom_post AND
: new.post_no = Sklad.post_no AND
: new.inv_numb = Sklad.inv_numb; (
/*% NotnullFK (:% New, В»IS NOT NULL ANDВ») */= 0
) _application_error (
,
'Cannot update Kyrjeru because Sklad does not exist.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tI_Postavka BEFORE INSERT ON Postavka for each row
ERwin Builtin Trigger
INSERT trigger on PostavkaNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Postavshiki Postavka on child insert restrict */
/* ERWIN_RELATION: CHECKSUM = «0000f5ca», PARENT_OWNER = »», PARENT_TABLE = «Postavshiki» _OWNER = »», CHILD_TABLE = «Postavka» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = «R_21», FK_COLUMNS = «post_no» */count (*) INTO NUMROWSPostavshiki
/*% JoinFKPK (:% New, Postavshiki, В»=В», В»ANDВ») */
: new.post_no = Postavshiki.post_no; (
/*% NotnullFK (:% New, В»IS NOT NULL ANDВ») */= 0
) _application_error (
,
'Cannot insert Postavka because Postavshiki does not exist.' ...
