Re: [GENERAL] Deleting Problem

2006-10-30 Thread Reece Hart
On Tue, 2006-10-31 at 10:24 +1100, Jamie Deppeler wrote: Here is my problem i have delete triggers on table5 and table6 which update summary information on table1,table2,table3,table4 if table5 or 6 gets delete, problem i am faced with is when eg table1 record gets deleted i

Re: [GENERAL] Deleting Problem

2006-10-30 Thread Stephan Szabo
On Tue, 31 Oct 2006, Jamie Deppeler wrote: > Here is my problem > > I have a level structure which is 5 levels deep with 6 tables, for this > example i will call it table1,table2,table3,table4,table5,table6 > > (1)table1 > (2)table2 > (3)table3 > (4)table4 > (5)table5,table6 > (6)table7,table8 >

[GENERAL] Deleting Problem

2006-10-30 Thread Jamie Deppeler
Here is my problem I have a level structure which is 5 levels deep with 6 tables, for this example i will call it table1,table2,table3,table4,table5,table6 (1)table1 (2)table2 (3)table3 (4)table4 (5)table5,table6 (6)table7,table8 table5 and table6 have fk keys pointing to table1,table2,table3