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

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
Received on Fri Sep 18 1998 - 10:39:17 CDT