Re: numeric data

This can be solved in one of 3 ways :
- use the MS-ODBC driver for Oracle. It comes with SP3 for Visual Studio (MDACxxx.EXE)
- use the Oracle 8.1.6.2 ODBC Driver. It now supports SQL_NUMERIC. You will have problems installing it if you use the 8.0.5 client networking. Install with oui (Oracle Universal Installer). Download from OTN.
- Change the data types from NUMBER (x,x) to REAL with :

     ALTER TABLE mytable MODIFY (mynumber REAL) The REAL values work with the Oracle ODBC drivers that come with 8.0.5 and VB6.0.

I wrote a PL/SQL script which changes all our tables. You don't lose any data, just precision on very large/small numeric values.

You don't say which versions of Oracle you use, so I just assumed the above, which does indeed have a problem.

Ted
-
On Sat, 23 Dec 2000 19:27:01 GMT, "Bert Bloemen" <bert.bloemen-NOSPAM-_at_pandora.be> wrote:

>Hello
>
>When I execute a query via Visual Basic to an oracle server, the numeric
>columns only contain "0" (zero's)
>example : select empno from emp; (empno is a numeric field) the whole
>column is 0
>
>But : select empno+0 from emp; works fine (no zero's, but the correct
>numbers)
>
>I'm using the Oracle ODBC Driver (I think this is the problem) via VB6.0
>
>can anybody help me out plzzzz ?
>
>tnkx !!!
>bbloemen
>
>

EMail: knijff_at_bigfoot.com Received on Wed Dec 27 2000 - 15:23:06 CST