Subject | RE: [firebird-support] Default Value not working |
---|---|
Author | Alan McDonald |
Post date | 2004-03-22T06:12:41Z |
> Hismells like you are actually inserting NULL into the field instead of not
>
> I am an old application where it uses FB 1.5. In a table I have declare
> a default value for some of the fields. When I test it under IBexpert it
> works fine. But under my application which uses IBX component, when an
> insert is made the default value that I declare doesn't work? Is there
> something I miss?
>
> Please advise.
>
> Regards,
> james
>
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