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

Hello again,

In fact, it seems that two values causes this fault to happen :

 One million : 1,000,000.00 which causes an overflow that you can check by converting the number valus to char, as follows

    SELECT TO_CHAR(MY_SILLY_COL) FROM MYTABLE, then you get the CHAR value ':00000'

The other value is 10,000,000,000.00, which converted to char gives ':000000000'

BTW, the Borland's tip about the MSVCRT.DLL doesn't work for me - my problems remains the same.

It seems to be a bug in certain versions of SQL*Net 2.3.2 is OK, 2.3.3 if buggous.

    Regards, Christophe Lauer.

Matthias Gresz a écrit:

> 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.
> / |\
> / / |\
> / __/| |\
> \° / | |\
> \/_/ | |\
Received on Mon Sep 21 1998 - 04:41:13 CDT