Subject Re: [ib-support] Default Question
Author Svein Erling Tysvær
<NULL>, I believe. The default value is used when the column is not
included in your INSERT statement, not to replace NULLs you set explicitly.
If you want it to change to 0, write an update (and possibly one insert)
trigger or set it in your program's BeforePost event or something.

Set

At 01:34 08.02.2001 -0500, you wrote:
>Hi:
>
> I have an edit control linked to VARCHAR(10) field and that field
contains a value,
>say '428'.
>The field has a DEFAULT of '0'. On the form, I put dataset in Edit and I
clear the
>entry then Post:
>
>DEFAULT Specifies a default value for column data; this value is entered
when no other
>entry is made;
>
>Will IB consider "no other entry is made" and insert the DEFAULT '0' or
will it go
>NULL?
>
>Thanks.