ign="justify">/*% NotnullFK (:% New, В»IS NOT NULL ANDВ») */= 0
) _application_error (
,
'Cannot insert Strynnue because Instrymentu does not exist.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tU_Strynnue AFTER UPDATE ON Strynnue for each row
ERwin Builtin Trigger
UPDATE trigger on StrynnueNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Instrymentu Strynnue on child update restrict */
/* ERWIN_RELATION: CHECKSUM = В«00011df7В», PARENT_OWNER = »», PARENT_TABLE = "Інструменти" _OWNER = »», CHILD_TABLE = В«StrynnueВ» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = В«is_aВ», FK_COLUMNS = В«nom_postВ» В«post_noВ» В«inv_numbВ» */count (*) INTO NUMROWSInstrymentu
/*% JoinFKPK (:% New, Instrymentu, В»=В», В»ANDВ») */
: new.nom_post = Instrymentu.nom_post AND
: new.post_no = Instrymentu.post_no AND
: new.inv_numb = Instrymentu.inv_numb; (
/*% NotnullFK (:% New, В»IS NOT NULL ANDВ») */= 0
) _application_error (
,
'Cannot update Strynnue because Instrymentu does not exist.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tI_Ydarnue BEFORE INSERT ON Ydarnue for each row
ERwin Builtin Trigger
INSERT trigger on YdarnueNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Instrymentu Ydarnue on child insert restrict */
/* ERWIN _RELATION: CHECKSUM = В«00012269В», PARENT_OWNER = »», PARENT_TABLE = "Інструменти" _OWNER = »», CHILD_TABLE = В«YdarnueВ» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = В«is_aВ», FK_COLUMNS = В«nom_postВ» В« post_no »« inv_numb В»*/count (*) INTO NUMROWSInstrymentu
/*% JoinFKPK (:% New, Instrymentu, В»=В», В»ANDВ») */
: new.nom_post = Instrymentu.nom_post AND
: new.post_no = Instrymentu.post_no AND
: new.inv_numb = Instrymentu.inv_numb; (
/*% NotnullFK (:% New, В»IS NOT NULL ANDВ») */= 0
) _application_error (
,
'Cannot insert Ydarnue because Instrymentu does not exist.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tU_Ydarnue AFTER UPDATE ON Ydarnue for each row
ERwin Builtin Trigger
UPDATE trigger on YdarnueNUMROWS INTEGER;
/* ERwin ...
