2012/5/8 trskopo <trskopo@...>

> **
>
>
> Hi all,
>
> I run sql statement via flamerobin, the statment is like this :
>
> SELECT * FROM M_INT_FRM a
> where a.ID_TRS_TYP = 100
>
> It will returns :
>
> ID ID_DIV_LC SCT_INI ID_TRS_TYP FRM_INI
> ========================================
> 4 8 MP 100 PO
> 5 9 MN 100 PO
> 6 0 MS 100 PO
>
> but if I change sql statement to this
>
> SELECT * FROM M_INT_FRM a
> where a.ID_TRS_TYP = 100
> and a.id_div_lc = 0
>
> no sql result returns
>
>
>

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]