Subject RE: [firebird-support] Default Value not working
Author Alan McDonald
> Hi
> 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

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.