Subject View Crashing Trigger
Author todd_pinel
I have an on after delete trigger that uses a view within it to
determine a count. When I delete from this table it actually
crashes my firebird server, if I use the exact SQL found in the view
in place of the actual view found in my delete trigger the delete
will operate properly.

The table I am deleting from is related to a detail table through a
single foreign key and the view I am using in the delete trigger is
accessing this detail table for a count.

This is the first time I believe I have tried to use a view in a
trigger and I can get around it no problem, although I am just
wondering if anyone knows or can explain why this is happening for
me? tia, Todd.