Triggers

How do you overcome a situation where there needs to be a delete trigger on a table that has referential constraints. I get an error no. -742 which says "Delete triggers and referential constraints cannot coexist. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Change the constraint as not to cascade deletes, and manually implement the delete within the trigger. Ugly, but no choice. -- Bashar Chalabi CTL, London badanhtt <giri_badanahattiNOgiSPAM@hotmail.com.invalid> wrote in message news:02000cac.11df5d2e@usw-ex0106-048.remarq.com... > How do you overcome a situation where there needs to be a delete > trigger on a table that has referential constraints. I get an error > no. -742 which says "Delete triggers and referential constraints cannot > coexist. > > > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * > The fastest and easiest way to search and participate in Usenet - Free! >