Реферат Розробка Бази даних та! Застосування для Інтернет-магазину відеотехнікі

error (

,

'Cannot delete Good because Delivery exists.'

); IF;

/* ERwin Builtin Trigger */

/* Good Ord on parent delete restrict */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Good" _OWNER = "", CHILD_TABLE = "Ord" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_4", FK_COLUMNS = "ID_good" */count (*) INTO NUMROWSOrd

/* % JoinFKPK (Ord,:% Old, "=", "AND") * /. ID_good =: old.ID_good; (NUMROWS> 0) _application_error (

,

'Cannot delete Good because Ord exists.'

); IF;

/* ERwin Builtin Trigger */

/* Good TV_monit on parent delete cascade */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" TV_monit "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */FROM TV_monit

/* % JoinFKPK (TV_monit,:% Old, "=", "AND") */_monit.ID_good =: old.ID_good AND_monit.Price =: old.Price AND_monit.Producer =: old.Producer AND_monit.Model =: old.Model AND_monit.Others =: old.Others;

/* ERwin Builtin Trigger */

/* Good Players on parent delete cascade */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Players "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */FROM Players

/* % JoinFKPK (Players,:% Old, "=", "AND") * /. ID_good =: old.ID_good AND.Price =: old.Price AND.Producer =: old.Producer AND.Model =: old.Model AND.Others =: old.Others;

/* ERwin Builtin Trigger */

/* Good Camera on parent delete cascade */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Camera "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */FROM Camera

/* % JoinFKPK (Camera,:% Old, "=", "AND") ...