Thanks for your replay.
If you see null with ibexpert, how come this data can be store in Firebird,
since ddl for this column not allow for null value? Could it be a bug in
Firebird?
Another strange results when issued this statement
SELECT * FROM M_INT_FRM a
where a.id_div_lc is null
It will returns 3 result (via flamerobin).
Thanks and regards,
Sugiarto
> I have tested your database and i think is an error of flamerobin, what you
> see 0 i see null with ibexpert. try
>
> SELECT * FROM M_INT_FRM a
> where a.ID_TRS_TYP = 100
> and a.id_div_lc is null
>
>
>
> May be in sometime you have changed the column from null to not null.
>
>
>
> Regards, Jesus
>
>
> [Non-text portions of this message have been removed]
>
