Re: Oracle and Floating Points

On Wed, 03 Dec 1997 09:12:53 -0600, dixon_at_tlh.fdt.net wrote:

>I have an Oracle 7.2 database with Delphi 2 front-end applications
>connected through SQL Links 3.5 and SQL*Net (version 2, I think). I need
>to do lookups on one table based on a primary key. Unfortunately, the
>primary key was defined as a NUMBER, which is not always precise (because
>it's a floating-point). The keys in the database are all stored
>correctly, but the key I'm searching for sometimes becomes imprecise. If
>I search for 123456789012, the Oracle engine will look for
>123456789011.999. The person who built the database and apps has since
>left the company, and I now have to fix this problem. I know the proper
>solution would be to change the column to a VARCHAR2 (or maybe NUMBER(12)
>- I'm new to Oracle, but I understand that's an integer), but that
>requires more time than we have available. Does anyone know of a
>workaround or a later version that solves this problem (although it's not
>really a bug)? TIA Michael Dixon dixon_at_tlh.fdt.net
>

Have you tried to create a view of the data using a select
to_char(myfield) myfield
from mytable
and then using that for the app
it seems like that would solve your problem in a few seconds. ========= ========= ========= ========= ========= Noah Monsey noah_at_azlink.com
========= ========= ========= ========= ========= The only dumb question is the one that you don't ask. ========= ========= ========= ========= ========= Oracle Master Database Administration April 1992 Oracle Master Application Development April 1992 ========= ========= ========= ========= ========= Received on Fri Dec 05 1997 - 00:00:00 CST