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
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Dec 03 1997 - 00:00:00 CST
