Oracle ODBC with MS Visual Studio

Hi,

using the Oracle ODBC driver, our numerics get truncated to x.0 on :

select mytext,sum(mynumber) as mynumber from mytable group by mytext

mynumber is numeric (12,2). The digits behind the decimal point don't show up in the result set in VB or VFP 6.0.

Using the MS ODBC driver works fine.

NLS_ parameters are set for Germany (decimal point is comma etc.)

Database is Oracle8i 8.1.6 or 8.0.5 EE, ODBC is 8.1.6.

Ted
EMail: knijff_at_bigfoot.com Received on Wed Dec 20 2000 - 14:45:52 CST