FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

>       Don't worry, although I used VARIANT type here in my 
> code, it can be
> compiled normally on solaris,(we used a tool called MainWin 
> which help us to
> compile Win32 program on the UNIX platform, so you see all 
> these programs
> can run normally under Win32 and UNIX platform without 
> changing a line of
> code, however on the win32 we can link to the odbc driver 
> provided by MS,
> but on UNIX we have no one but you to turn to)
>       So here is the problem, if this program is running 
> under Win32 and using
> odbc driver provided by the Mircosoft, it always return as 
> SQL_REAL, but
> using FreeTDS I always got SQL_FLOAT/SQL_DOUBLE. so I thought 
> maybe you want
> to change it in your code.

Fixed. ODBC make we confused with SQL_C_FLOAT (32bit) and SQL_FLOAT (64bit).
I changed all code to not use SQL_FLOAT but only SQL_DOUBLE (two constant
for the same type... I don't understand the reason!).

>       By the way, no matter which driver I use, win32 or 
> solaris, the value will
> be 33.139999 instead of 33.14, but tsql do can get 33.14. I 
> thought it is
> because it fetch the data using string format.
> 
>       thank you
>       Ou
> 

This is precision problem... perhaps tsql do different rounding...
Thanks for all your testing... I have to add another test now...

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================