Subject Re: Question about triggers
Author firebirdsql
Do you know if the check constraints are checked at the end of the statement or when a row is inserted?

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > Do table triggers fire for each row or per set? When you use a merge statement, I'm guessing the trigger fires for each row?
>
> Triggers in Firebird fire per affected row and not per statement.
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>