n="justify">/*% NotnullFK (:% New, В»IS NOT NULL ANDВ») */= 0
) _application_error (
,
'Cannot insert Instrymentu because Sklad does not exist.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tD_Instrymentu AFTER DELETE ON Instrymentu for each row
ERwin Builtin Trigger
DELETE trigger on InstrymentuNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Instrymentu Dyhovue on parent delete cascade */
/* ERWIN_RELATION: CHECKSUM = В«0002730bВ», PARENT_OWNER = »», PARENT_TABLE = "Інструменти" _OWNER = »», CHILD_TABLE = В«DyhovueВ» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = В«is_aВ», FK_COLUMNS = В«nom_postВ» В«post_noВ» В«inv_numbВ» */FROM Dyhovue
/*% JoinFKPK (Dyhovue,:% Old, В»=В», В»ANDВ») * /. nom_post =: old.nom_post AND.post_no =: old.post_no AND.inv_numb =: old . inv_numb;
/* ERwin Builtin Trigger */
/* Instrymentu Ydarnue on parent delete cascade */
/* ERWIN_RELATION: CHECKSUM = В«00000000В», 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В» */FROM Ydarnue
/*% JoinFKPK (Ydarnue,:% Old, В»=В», В»ANDВ») * /. nom_post =: old.nom_post AND.post_no =: old.post_no AND.inv_numb =: old . inv_numb;
/* ERwin Builtin Trigger */
/* Instrymentu Strynnue on parent delete cascade */
/* ERWIN_RELATION: CHECKSUM = В«00000000В», 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В» */FROM Strynnue
/*% JoinFKPK (Strynnue,:% Old, В»=В», В»ANDВ») * /. nom_post =: old.nom_post AND.post_no =: old.post_no AND.inv_numb =: old . inv_numb;
ERwin Builtin Trigger;
/TRIGGER tU_Instrymentu AFTER UPDATE ON Instrymentu for each row
ERwin Builtin Trigger
UPDATE trigger on InstrymentuNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Instrymentu Dyhovue on parent update cascade */
/* ERWIN_RELATION: CHECKSUM = В«000530cbВ», PARENT_OWNER = »», PARENT_TABLE = "Інструменти" _OWNER = »», CHILD_TABLE = В«DyhovueВ» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = В«is_aВ», FK_COLUMNS = В«nom_postВ» В«post_noВ» В«inv_numbВ» */
/*% JoinPKPK (:% Old,:% New, В»<>В», В»ORВ») */