Subject | Re: [ib-support] Default Question |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-02-08T07:10:18Z |
<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:
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:contains a value,
>
> I have an edit control linked to VARCHAR(10) field and that field
>say '428'.clear the
>The field has a DEFAULT of '0'. On the form, I put dataset in Edit and I
>entry then Post:when no other
>
>DEFAULT Specifies a default value for column data; this value is entered
>entry is made;will it go
>
>Will IB consider "no other entry is made" and insert the DEFAULT '0' or
>NULL?
>
>Thanks.