U can use the latest version of WinZeos 5.0.3 Hope it helps....
R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No. (Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -----Original Message----- From: Iago Sineiro [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 2:22 AM To: Zeos Hackers Mail List; Zeos General Mail List; MySql Mail List Subject: Type of column in query float instead of integer 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 --------------------------------------------------------------------- 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