VB6 and Oracle Number Datatype Problem

From: Lou da Silva <binkylou_at_world.std.com>
Date: Mon, 11 Sep 2000 19:47:49 GMT
Message-ID: <Pine.SGI.3.95.1000911153511.4154A-100000@world.std.com>

Hi All,

Has anyone else experienced this problem? I am trying to populate an ADODB Recordset with the following statement:

SELECT Bind_Id, Binding from Bindings;

The Bind_Id column is defined as number(2). This select statement populates my recordset with all the valid values in the Binding column, but the Bind_Id always comes back empty.

Just playing around, I changed the SQL to this:

SELECT Upper(Bind_Id), Binding FROM Bindings;

and I now get back the values in the Bind_Id column [this also works with Lower(Bind_Id)].

I'm wondering why I would have to use what I thought was a character function on a number field for this to work in VB.

BTW: Using VB6, ORACLE OBDC Driver v 8.00.05.00, MSADO 2.0, Oracle Enterprise v8.1.6.1.0 [as well as Oracle 8i Personal Edition v8.1.6]

Thanks,

Lou Received on Mon Sep 11 2000 - 14:47:49 CDT