Kevin X Lin writes:
> Hi there,
>
> I'm running into problems with functions "floor/ceiling" when I use
> Visual Basic to talk to mySQL through myODBC.
>
> My code looks like this:
> sSQL = "select floor(3.2)"
> Set rs = MySQL_conn.Execute(sSQL)
>
> I got rs.eof = true after execution of the query. However the following
> codes works fine.
> sSQL = "select round(3.2)"
> Set rs = MySQL_conn.Execute(sSQL)
> rs.fields(0)=3
>
> Can anyone tell if this is a bug of myODBC or VB's problem?
>
Sorry, but what is your problem ??
round(3.2) = 3
The above is quite true. As you have not specified number of decimals,
MySQL is using default of 0, which conforms with SQL 92 standard.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
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