At 20:22 +0200 6/26/02, Iago Sineiro wrote:
>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
>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?
FLOOR() might help you.
>Note: I use Delphi components WinZeos 3.0.2.
>Thanks in advance.