Re: Oracle, IIS 4.0 Returning 0's for Number fields

From: Carey Martinez <carey.martinez_at_gwl.com>
Date: Mon, 13 Dec 1999 09:06:18 -0700
Message-ID: <83359q$bqg$1@is-news.gwl.com>

Finally found Answer in FrontPage 2000 booklet.

here it is.

Remove the precision from the oracle tables change column to number. After doing this the figures showed up. Don't ask me how or why, it just works. After doing this to all the application tables the app works like a charm. I am now testing the application to make sure all components work.

Carey Martinez <carey.martinez_at_gwl.com> wrote in message news:82oi0q$di4$1_at_is-news.gwl.com...
> Good Morning,
>
> I have a developer who is creating an Web based application using VB, IIS
> 4.0 and trying to access an Oracle 734 database. I have installed the
> Oracle8i Client software. This resolved our connection problems to the
> oracle database, however, every time we attempt to retrieve a number field
> the field is returned with a 0. All character fields come back fine. Any
> Ideas?
>
> Thanks
>
> Carey Martinez
> carey.martinez_at_gwl.com
>
>
Received on Mon Dec 13 1999 - 10:06:18 CST