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 !