Hi all.

I execute the next query in Delphi 5.0 against MySQL and Delphi understand
that the column of the query is of type ftFloat
when it should be ftInteger (The field cantidad in the database is int).

SELECT SUM(cantidad) AS Ventas
FROM LALBARANCL
WHERE fecha >= "2002-05-01"
AND fecha < "2002-05-02"
AND idArticuloInfo = "ART:0:48247"'

The same query without the SUM function results integer type.

How could I change the result type from float to integer?

Note: I use Delphi components WinZeos 3.0.2.

Thanks in advance.



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to