Problem with SELECT

Kryptonyx

Hello,
i will make export tools from our Navision Financials 2.0 to MySQL database.
I connect to Navision via ODBC driver and develop with Delphi.

I make Query like this:
Query2.SQL.Add('SELECT Nr_, SUM(Amount) as Amount');
Query2.SQL.Add('FROM Cust WHERE ... ');

But as results become Amount without comas, etc. if result will be 1000.56 i become 1000.

How to solve this problem ??

Thanks.

kine

I think it is problem of the C/ODBC driver in version 2.00, you need to do upgrade to another version... sorry...