Access MDB file - Datatype

[Qatan]

Hello,

 

    I need to get a value from a MDB (97) database from a field type "single" (lenght 4).

 

    The rows have values like:

 

    0.045

    1.473

    5.2664

    24

   

 

    But what I get is only:

 

    0

    1

    5

    24

 

    I am using hbodbc to access the database and I use ::FieldByName( 'qtd' ):Value 

    I am not sure if I should set something to get the precise value instead of integer numbers.

    Any idea? Has someone the same problem trying to get type "single" values from MDB files?     

    http://msdn.microsoft.com/en-us/library/xay7978z(VS.80).aspx

    http://articles.techrepublic.com.com/5100-10878_11-5978932.html

    According to the links above the datatype "single" is precise enough for what I need and shouldn´t be a problem when accessed in a MDB 97 file via harbour ODBC. I may be doing something wrong... For "long" datatype it works fine. 

 

    Thanks for any help.

 

Qatan