Re: How to retrieve the type of an column using OO40

In article <afd2a143.0311010355.ece9c75_at_posting.google.com>, kurt- erich.finger_at_arcor.de says...
> VB6
> OO40 3.0
>
> I am using Oracle Objects with VB6 to retrieve data from an Oracle database.
> I have a simple SQL statement and I am using the OraDynaset.
> The Dynaset contains columns of more than one table.
> I retrieve the fields from the OraDynaset using OraDynaset.Fields(i)
>
> How do I know the type of the underlying Oracle datatype?
> Apparently ther is no fields(i).type property like in MS ADO OLEDB
> (which I don't want to use because the connect times are too slow)
> In the help file I could not find anything.
>
> Kurt-Erich
>

You can't get the type directly from the dynaset, but you can use the OraMetaData interface to describe objects.

• Tom