problem with the number 1,000,000?
Date: Wed, 24 Mar 1999 07:56:45 -0500
Message-ID: <1f5K2.2151$cP.14845_at_news7.ispnews.com>
Hi. I have an application that is written in Access and stores its data in Oracle. This application has been running successfully for quite some time.
Now, I use ODBC to connect to Oracle. We've come across a glitch (perhaps a bug?) and I do not know how to correct it.
The client has inserted a value of 1,000,000 into a numeric field (double). If I go to SQL* and look up the value, it comes back as 1,000,000. However, if I look at it in Access, via ODBC, I get 1.8* 10^302 as the value. This, of course, crashes my system. Now, I've done some testing. I insert 1,000,001 and everything works fine. I insert 999,999.99 and everything is fine. I insert 1,000,000.01 and everything is fine. It only fails, and ALWAYS fails, when I enter 1,000,000. I even tried 1,000,000,000, and it worked.
Does anyone know if there is a problem with the number 1 million in Oracle's ODBC driver? Any help would be greatly appreciated.
Thanks.
--Rob Received on Wed Mar 24 1999 - 13:56:45 CET