| Subject | Re: [firebird-support] FB 1.5 triggers - appear to work as 'FOR EACH ROW' |
|---|---|
| Author | Jacqui Caren |
| Post date | 2004-07-29T21:05:22Z |
> At 05:01 AM 29/07/2004 +0000, you wrote:[snip]
>
>>Hi all,
>>Unless I have missed some doco, it appears that when a trigger is
>>defined, it fires once for each affected row. Is that correct? If
>>so, does anyone know a way to get FB to for for all rows affected by
>>an event (eg update)?
I assume that you have existing Oracle row/statement level
triggers that you wish to migrate to firebird?
Firebird triggers fire per row updated - there are no
statement level triggers.
Jacqui