Subject | Per-command triggers not supported, right? |
---|---|
Author | PenWin |
Post date | 2011-06-15T12:12:10Z |
Hi!
I just need a confirmation: Firebird used to only support per-record
triggers, not per-command triggers. Is that true even with new versions
of Firebird (2.5 or even the development builds of 3.0)?
I mean:
- per-record: `UPDATE table SET value=0` fires as many times are there
are records in table.
- per-command: `UPDATE table SET value=0` fires once, regardless of the
number of records in table.
Just that I don't search for something which doesn't exist...
Thanks,
Pepak
I just need a confirmation: Firebird used to only support per-record
triggers, not per-command triggers. Is that true even with new versions
of Firebird (2.5 or even the development builds of 3.0)?
I mean:
- per-record: `UPDATE table SET value=0` fires as many times are there
are records in table.
- per-command: `UPDATE table SET value=0` fires once, regardless of the
number of records in table.
Just that I don't search for something which doesn't exist...
Thanks,
Pepak