Ali,

> if u use a field as unique indexed for rec_id or like that
> table x..(
> Xfield integer unique;
> )
>
> you cant send xfield as null to before insert trigger, even you want.
> ib returns with validation error without calling the trigger.

you must have an app. middleware performing the validation *before* the
insert statement gets sent to the server.
IB will definately let before insert trigger fill NULL fields, that is
one of their main purposes.
The "if null" test lets you avoid errors when another client app. that
doesn't fetch the value in advance tries to insert a record (passing a
NULL state for the key field).
HTH
--
____
_/\/ando