MySql Int Filed rounds 2 decimals

[BiJae]

I have two fields that I'm trying to report from a MySql 5.0 database. The fields are both int(10). I can see in the database that the values are correctly recorded to the third decimal place, i.e. 10.125. However when I run my Crystal report I am receiving 10.130 as the reported value.

I am doing no manipulation this field. I've looked through previous posts and updated my mysqlodbc driver.

Has any one ever encountered this before? Do you know of the fix?

Thank you,

http://www.bijae.net

"If the only prayer you said in
your whole life was, 'thank you,'
that would suffice."
-- Meister Eckhart

 

[BiJae]

Cancel that request.. I found the problem, my default value for rounding was set to .01.

http://www.bijae.net

"If the only prayer you said in
your whole life was, 'thank you,'
that would suffice."
-- Meister Eckhart

 

[Turkbear]

Hi,
MySql allows an INT ( which usually means Integer) to have Decimal places??






To Paraphrase:"The Help you get is proportional to the Help you give.."