> 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?
You can use something like: SELECT SUM(cantidad) & 0xFFFFFFFF AS Ventas FROM LALBARANCL WHERE fecha >= "2002-05-01" AND fecha < "2002-05-02" AND idArticuloInfo = "ART:0:48247"' /GG --------------------------------------------------------------------- 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
