Subject RE: [firebird-support] About trigger
Author Svein Erling Tysvær
>Hello,
>
>when i execute several insert (or update or delete), is it possible to create a trigger that will be raise not on each
>insert/update/delete but at the end of these "bulk" inserts ? i can off course call the stored procedure from the program
>but for good database integrity i prefer that the database do it itself ... i thing that their is no possibilities to do
>so but in case ....

What are you trying to do, Nathan? BEFORE triggers typically update the same row, so I expect you're looking for some kind of AFTER trigger, but beyond that I do not understand. Maybe things have to be done differently in Firebird - either by a trigger on each row or possibly in a combination of a trigger on each row and a ON COMMIT trigger?

Set