Em 7/5/2012 21:51, trskopo escreveu:

> 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.
>
> You can download the database at http://www.mediafire.com/?bx8k29kt7x2ucks
>
> Strange, could it be a bug?
>
> Thanks and regards,
> Sugiarto
>

What the datatype of ID_DIV_LC column ?

what about:

SELECT * FROM M_INT_FRM a
where a.ID_TRS_TYP = 100
and a.id_div_lc between -0.1 and 0.1

see you !