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

From: Markus Schwitter (Bitec) <MrMagoo_at_plaza.ch>
Date: Thu, 17 Sep 1998 11:23:01 +0200
Message-ID: <6tqkdq$bbg$1@news.uk.ibm.net>

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 Thu Sep 17 1998 - 04:23:01 CDT