Subject | RE: [firebird-support] About trigger |
---|---|
Author | Svein Erling Tysvær |
Post date | 2012-02-03T07:17:38Z |
>Hello,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?
>
>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 ....
Set