[GENERAL] Cascading Trigger - changing row on delete does not delete row

2008-02-25 Thread D. Dante Lorenso
All, I have 2 tables which both have triggers on them. When I delete a row on table A, a cascading trigger ends up modifying rows in table B. The modified rows in table B trigger an update on rows in table A which happens to be the same row that I am trying to delete. I don't get any error

[GENERAL] Cascading Trigger - changing row on delete does not delete row

2008-02-24 Thread D. Dante Lorenso
All, I have 2 tables which both have triggers on them. When I delete a row on table A, a cascading trigger ends up modifying rows in table B. The modified rows in table B trigger an update on rows in table A which happens to be the same row that I am trying to delete. I don't get any error

[GENERAL] Cascading Trigger - changing row on delete does not delete row

2008-02-24 Thread D. Dante Lorenso
All, I have 2 tables which both have triggers on them. When I delete a row on table A, a cascading trigger ends up modifying rows in table B. The modified rows in table B trigger an update on rows in table A which happens to be the same row that I am trying to delete. I don't get any error