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=egroupweb/S=1705115386:HM/EXP=1080022197/A=1950447/R=0/SIG=1245hvqf1/*http://ashnin.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/>.
>
>