Kylix: Floats from MySQL end up truncated in app

Hello there,

I'm new to Delphi/Kylix, so perhaps there's someone to help me out with kind of a strange problem.

My application accesses a MySQL (3.23) server and tries to fetch some data from a table that includes a float column.

Whenever I do something like
SQLQuery1.FieldByName('floatcolumn').AsFloat
I end up with an integer value (well, typed as float though).

There's nothing wrong with the query, this doesn't even work when I use a TDBGrid to display rows from that table. A manual query via telnet e.g. reveals:

mysql> select floatcol from sometable;
+---------+
| floatcol |
+---------+
| 83.7 |
| 83.2 |
| 84.1 |
| 82.8 |
| 83.5 |
| 83.3 |
| 84.4 |
| 83.5 |
+---------+
8 rows in set (0.00 sec)

The DBGrid only shows these numbers as
83
83
84
82

and so on.

Any ideas what could be wrong here? I'm using Kylix 3.

I would check the underlying TField value and see what the value of TField.Precision is set to.

Thanks for the hint. Help however says, that the "Precision" property must be greater than 2 and that it is automatically set to 2 if someone/something tries to set it to a value less than 2.

In my case, the Precision is zero