Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: VB5 RDO problem when using vaules exactly 1000000, results in :00000
We had the same problem. It happned to us only with a value of one
million. We fixed the problem by redefining all numeric fields by
specifying precision. Most of our doubles are now defined as
number(16,4). BTW, we are using the Oracle 7.3 driver.
How about some help, if you can, in return. Using the rdocolumns collection we cannot access any of the system tables, like USER_TABLES, USER_COLUMNS, etc, yet we can access them with SQLPlus, using the same UID and Password. Any use of rdocolumns("user_Table") triggers the error "Item not found in this collection." Any ideas?
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).
Received on Wed Sep 23 1998 - 21:14:45 CDT