Subject Re: [ib-support] Re: Interbase Transactions
Author Ali Gokcen
Post date 2000-12-15T11:07:02Z
nando,
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

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


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com