Isn't this one of the silliest things? Why in the world would a default
value not work. IMHO, it should not matter if your insert statement
includes a field that is null. If the column is defined w/ a default value,
the table should use it, otherwise don't define a default value. This
produces a lot of extra code (before insert triggers) just to make sure of
values. Ugh.
This logic on this one has always baffled me. (which is easy to do these
days :-)
Kevin

-----Original Message-----
From: James [mailto:james_027@...]
Sent: Sunday, March 21, 2004 10:39 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Default Value not working


Hi Alan

> smells like you are actually inserting NULL into the field instead of

not

> inserting any value at all. If you make sure that you do not place the
> field
> in the insert statement at all it will get the default value. If it has

to

> be there then you will have to use a before insert trigger.
> Alan

How stupid am I not to check the InsertSql properties. Yes I am
inserting NULL into the field that makes the default value not working.
Thanks a lot.

Cheers,
James

>
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
>

<http://rd.yahoo.com/SIG=12cvese0k/M=268585.4521611.5694062.1261774/D=egroup
web/S=1705115386:HM/EXP=1080022197/A=1950447/R=0/SIG=1245hvqf1/*http://ashni
n.com/clk/muryutaitakenattogyo?YH=4521611&yhad=1950447>

>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>

<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>

----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]