Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
ASE Driver Version 15.5.0.1000, ODBC Version 03.1 -- problem with multiplication of fractions?
3 views
Skip to first unread message
ALEX BIRCHALL
Dec 28, 2014, 7:50:30 AM12/28/14
to
Hello,
The problem is that we have a report the results of which include monetary values. The SQL looks like this:
"select ... fee_amount*.01, ....."
This report produced valid results until we upgraded from ASE 12.5 to ASE 15.5 last year. Now the value displayed is always "0.00".
The details of the ASE driver are:
ASE Driver Version 15.5.0.1000, ODBC Version 03.1. We are working on a Windows 7 platform.
Our quick fix is to revert to using the old ASE ODBC Driver, but this is not ideal.
Is there any way that I can configure the driver (perhaps via the Initialization String) so that it produces the correct results?
Many thanks!
Alex
The problem is that we have a report the results of which include monetary values. The SQL looks like this:
"select ... fee_amount*.01, ....."
This report produced valid results until we upgraded from ASE 12.5 to ASE 15.5 last year. Now the value displayed is always "0.00".
The details of the ASE driver are:
ASE Driver Version 15.5.0.1000, ODBC Version 03.1. We are working on a Windows 7 platform.
Our quick fix is to revert to using the old ASE ODBC Driver, but this is not ideal.
Is there any way that I can configure the driver (perhaps via the Initialization String) so that it produces the correct results?
Many thanks!
Alex
0 new messages