align="justify"> 'Cannot insert Sklad because Postavka does not exist.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tD_Sklad AFTER DELETE ON Sklad for each row
ERwin Builtin Trigger
DELETE trigger on SkladNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Sklad Instrymentu on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = «000217ef», PARENT_OWNER = »», PARENT_TABLE = «Sklad» _OWNER = »», CHILD_TABLE = «Instrymentu» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = «R_28», FK_COLUMNS = «nom_post» «post_no» «inv_numb» */count (*) INTO NUMROWSInstrymentu
/*% JoinFKPK (Instrymentu,:% Old, В»=В», В»ANDВ») * /. nom_post =: old.nom_post AND.post_no =: old.post_no AND.inv_numb =: old . inv_numb; (NUMROWS> 0) _application_error (
,
'Cannot delete Sklad because Instrymentu exists.'
); IF;
/* ERwin Builtin Trigger */
/* Sklad Kyrjeru on parent delete restrict */
/* ERWIN_RELATION: CHECKSUM = «00000000», 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 NUMROWSKyrjeru
/*% JoinFKPK (Kyrjeru,:% Old, В»=В», В»ANDВ») * /. nom_post =: old.nom_post AND.post_no =: old.post_no AND.inv_numb =: old . inv_numb; (NUMROWS> 0) _application_error (
,
'Cannot delete Sklad because Kyrjeru exists.'
); IF;
ERwin Builtin Trigger;
/TRIGGER tU_Sklad AFTER UPDATE ON Sklad for each row
ERwin Builtin Trigger
UPDATE trigger on SkladNUMROWS INTEGER;
/* ERwin Builtin Trigger */
/* Sklad Instrymentu on parent update restrict */
/* ERWIN_RELATION: CHECKSUM = «0003a2dd», PARENT_OWNER = »», PARENT_TABLE = «Sklad» _OWNER = »», CHILD_TABLE = «Instrymentu» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = «R_28», FK_COLUMNS = «nom_post» «post_no» «inv_numb» */
/*% JoinPKPK (:% Old,:% New, В»<>В», В»ORВ») */
: old.nom_post <>: new.nom_post OR
: old.post_no <>: new.post_no OR
: old.inv_numb <>: new.inv_numbcount (*) INTO NUMROWSInstrymentu
/*% JoinFKPK (Instrymentu,:% Old, В»=В», В»ANDВ») * /. nom_post =: old.nom_post AND.post_no =: old.post_no AND.inv_numb =: old . inv_numb; (NUMROWS> 0) _application_error ...
