--- In firebird-support@yahoogroups.com, Alexandre Benson Smith <iblist@...> wrote:

>
> 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 !
>

Still no result.

Here is the table structure
CREATE TABLE M_INT_FRM
(
ID Integer NOT NULL,
ID_DIV_LC Integer NOT NULL,
SCT_INI Varchar(2) NOT NULL,
ID_TRS_TYP Integer NOT NULL,
FRM_INI Varchar(2) NOT NULL,
PRIMARY KEY (ID)
);

Thanks & regards,
Sugiarto