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