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

Home -> Community -> Usenet -> c.d.o.misc -> Re: VB5 RDO problem when using vaules exactly 1000000, results in :00000

From: Markus Schwitter (Bitec) <MrMagoo_at_plaza.ch>
Date: Mon, 28 Sep 1998 19:45:03 +0200
Message-ID: <6uoigd$efi$2@news.uk.ibm.net>

>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.

Uh, that's a way we cannot go, because the Database is given.

>
>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?

I have never tried system columns.....But, try the new RDO Driver that comes with
VB6, and the ODBC that comes with it (or with OLE DB SDK). We are using them now.

Regards Markus Received on Mon Sep 28 1998 - 12:45:03 CDT