Subject Re: [ib-support] Re: Interbase Transactions
Author Ali Gokcen
Post date 2000-12-15T12:58:27Z
ok,  you are right,  sorry me.
i tested some entry via command line ISQL  at last.
its a big suprise for me :) 
BDE alias based programs and IBconsole made me wrong.
my outlook was set  "plain text" for news sending. :(  
----- Original Message -----
Sent: Friday, December 15, 2000 1:35 PM
Subject: Re: [ib-support] Re: Interbase Transactions

Ali,
could you please avoid posting in HTML in this list? Thanks.

> you cant create UNIQUE index without  NOT NULL expression  ok?

No you can't.

> IB isnt check  NOT NULL ?  yes it checks !

Of course it performs the check.

> ok, when?
> after SQL parsing?
> after Trigger running ?
> after insert ?

I believe the sequence is something like:

0- a lot of things we aren't interested in right now.
1- prepare the record with the values sent from the client.
2- fire any before insert trigger passing the record in the NEW. context
variables.
3- apply the checks to the record optionally modified by the triggers.
4- if the checks pass, insert the record.

So, as I see things, you *can* pass a NULL state, provided that you have
a BEFORE INSERT trigger that will fill in a value.
If you get an errore before step 2, then you probably have some
middleware (like the BDE or the Delphi VCL) performing a chack based on
the NOT NULL definition of the field (or the state of the Required
property of a TField object, for example).
Regards
--
    ____
_/\/ando