🚀 go-pugleaf

How come I never though about that?

I will try,

thanks!

Mika

"Martijn Tonies" <m.tonies@upscene_remove.com> kirjoitti viestiss�
news:3df8a7e5@newsgroups.borland.com...
> 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."
> > >
> > >
> >
> >
>
>