Problem Reading Acces TODBC type data Single

[eldonfsr]

Hi i have a problem reading a access table  all fields show information but only 2 fields don't show me information always show 0 not real value it has, Pnqty witch is define as SINGLE, I read as float as integer as long integer but nothing show me information some idea what can happend.

Code: Pascal  [Select][+][-]

1.         tsqlm.ParamByName('ppnqty').AsFloat  := TsqlOdbc.FieldByName('PNQty').AsFloat;
2.          tsqlm.ParamByName('ppnqty2').AsFloat := TsqlOdbc.FieldByName('pnqty2').AsFloat;

thanks