|Subject||Re: [ib-support] Re: Interbase Transactions|
you cant create UNIQUE index without NOT NULL expression ok?
IB isnt check NOT NULL ? yes it checks !
after SQL parsing?
after Trigger running ?
after insert ?
----- Original Message -----From: Nando DessenaSent: Friday, December 15, 2000 12:58 PMSubject: Re: [ib-support] Re: Interbase TransactionsAli,
> 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: