At 09:08 AM 08-02-01 -0500, you wrote:

>Hi:
>
> > On an update, it will go NULL. Defaults only apply to inserts and they are
> > only set if the insert doesn't specify something in the column. Passing
> > NULL in the insert statement will cause the column to be NULL. If you
> > exclude the column from the Values() list in the insert, you will get the
> > default.
> >
> > If you need the column to go to zero whenever it gets set null, you'll need
> > a BU trigger to do that.
>
> Anh! not the answer I wanted but oh well. Will keep the code setting it
> to '0'.
>
> OnExit If('') then '0'. Oh well.

I suppose you know that ('') is not null.

HB


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________