Subject Re: [firebird-support] Re: Non null column, before insert trigger not filling column, Delphi
Author Mark Rotteveel
> 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