Subject Re: [ib-support] Re: Interbase Transactions
Author Ali Gokcen
you cant create UNIQUE index without  NOT NULL expression  ok?
IB isnt check  NOT NULL ?  yes it checks !
ok, when?
after SQL parsing?
after Trigger running ?
after insert ?
----- Original Message -----
Sent: Friday, December 15, 2000 12:58 PM
Subject: Re: [ib-support] Re: Interbase Transactions


> 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).

To unsubscribe from this group, send an email to: