Re: VB5 RDO problem when using vaules exactly 1000000, results in :00000

Hi,

take a look at Chritophe Lauers' posintg:

Hi evrybody,

I'm so happy to have finally found the answer that i decide to give it to you all :

Using Delphi (or any other dev. tool), when i did

    UPDATE MY_TABLE SET MY_COL = :p_MyValue , il p_MyValue is 1,000,000.00
i got finally and overflow value in the column 1.797xxxE308, and TO_CHAR(MY_COL) gives ':0000' as a result.

The trouble seems to come from a MS VC++ dll used by some misc component of the Oracle / SQL*Net / ODBC pipe :

(This come from Borland, in the Delphi Tips ... )

TA1998091470 - BDE / Oracle 7 and the value, 1 million

Oracle 7 and the value, 1 million

Product        : BDE [all versions]
Author         : European Professional Services

DESCRIPTION We have, at various times, received reports of people unable to enter numbers of the value
of exactly 1 million into Oracle 7 tables. It has come to our attention that the problem
does not lie with the BDE, nor even with Oracle's SQL*Net, but with the version of the
Visual C++ Runtime library, MSVCRT.DLL installed on your system. The workaround, therefore,
is to swap to a different version of MSVCRT.DLL. One MSVCRT version that

has been shown to work is 5.00.7303.

Valeri Disko schrieb:
>
> I coul be ODBC driver problem.
> Try OO4O (Oracle Objects for OLE). It comes with standard Oracle
> client side setup.
> You'll find a lot of samples and help file there for VB.
> Good luck.
>
> Markus Schwitter (Bitec) wrote:
>
> > I have a quite 'silly' error using Visual Basic 5 SP3, and Oracle 7.3 :
> >
> > Whe I update a double in a Table using this
> >
> > with rs
> > .edit
> > !BETRAG = 1000000
> > .update
> > end with
> >
> > I will have an entry in the database with the vaule :00000 (when retrieve
> > this
> > using ODBC-Test from Oracle). When I read back this value, there is an
> > error like 'overflow' or 'out of range', and VB shows 1.7x10E308 (the max
> > value for a double). When I update the field using the values 999999 or
> > 1000000.01, there will be no problem. Any other value is also not a problem,
> > I have tried several random numbers in a loop. Has anybody a hint for this
> > issue ?
> >
> > We have tried the MS-ODBC-Driver and also the Oracle Driver.
> >
> > Regards Markus Schwitter

--

Regards

Matthias Gresz :-)

--
Matthias.Gresz_at_Privat.Post.DE

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\