🚀 go-pugleaf

How about adding a trigger (that fires last) that checks the field
for NULL and sets it to 0 as default?

And, of course, the NOT NULL constraint.


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> The problem lies a little deeper since there are certain triggers and
> other activities that cretes new lines to that table. I need to make sure
> that there is never  a line with NULL value.
>
> The table should be like this
>
> CREATE TABLE MYMISTAKE (
>    NR  INTEGER NOT NULL,
>    PROBLEM INTEGER NOT NULL,
>    .....
>   )
>
> or
>
> CREATE TABLE MYMISTAKE (
>    NR  INTEGER NOT NULL,
>    PROBLEM INTEGER DEFAULT 0,
>    .....
>   )
>
> but now it is
>
> CREATE TABLE MYMISTAKE (
>    NR  INTEGER NOT NULL,
>    PROBLEM INTEGER,
>    .....
>   )
>
> so I should be able to add that constraint which make that value = 0
> if the insert don't set that PROBLEM field
>
> Mika Parjanen
>
> "Martijn Tonies" <m.tonies@upscene_remove.com> kirjoitti viestiss�
> news:3df841c4@newsgroups.borland.com...
> > Hi,
> >
> > > just a simple question:
> > >
> > > How can I set a field NOT NULL constraint afterwards.
> > > There is a lot of data in that table and too much depencies
> > > so I cannot drop and recreate that field again.
> > >
> > > I suppose "DEFAULT 0"  would also be enough.
> >
> > In IB6 or higher, it should be.
> >
> > Also simply filling the column yourself,
> > UPDATE ... SET MYCOL = 0 WHERE MYCOL IS NULL
> >
> > would do the same thing.
> >
> > > This is a problem because I have triggers which
> > > increment and decrement that value and that can't be done
> > > if value is NULL.
> >
> >
> >
> > --
> >
> > With regards,
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase & Firebird
> > Firebird Workbench - the developer tool for Firebird
> > Upscene Productions
> > http://www.upscene.com
> >
> > "This is an object-oriented system.
> > If we change anything, the users object."
> >
> >
>
>