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

Reply via email to