Subject Re: Non null column, before insert trigger not filling column, Delphi
Author Mike
Mark,

Many thanks.

Mike


--- In firebird-support@yahoogroups.com, "Mark Rotteveel" <Avalanche1979@...> wrote:
>
> > Maybe Firebird is different from Oracle in that I have successfully
> > created my ID column as a primary key without the non-null constraint. So, it's
> > possible even if not perhaps advisable.
>
> AFAIK yhe primary key in Firebird doesn't need a NOT NULL constraint, as I think the primary key enforces NOT NULL by itself. So if the NOT NULL constraint itself is a cause of the problem, you should be able to leave it out in the case of the primary key.
>
> Mark
> --
> GMX DSL: Internet-, Telefon- und Handy-Flat ab 19,99 EUR/mtl.
> Bis zu 150 EUR Startguthaben inklusive! http://portal.gmx.net/de/go/dsl
>