Subject Re: [firebird-support] Default value in DDL not work
Author Mark Rotteveel
On 5-6-2019 10:22, m_brahim11@... [firebird-support] wrote:
> I build tables under IBEXPERT and define some fields with default value
> I except 0 as value but has always NULL
> Any idea ?
If you do `insert into yourtable (other_field, field_name) values
('somevalue', null)` then the default will not be applied because you
explicitly set the field to null.

A default will only be applied if you omit the field: `insert into
yourtable (other_field) values ('somevalue')`. After this statement,
`FIELD_NAME` will have value 0.

If that is not your use case, please show a reproducible example so we
understand what you mean.

Mark Rotteveel