> Do you know if the check constraints are checked at the end of the statement or when a row is inserted?

At insertion time. Firebird doesn't support deferred constraints.

--
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!

> --- 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!
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>