Return column type from database

[AtleOlsen]

Is there anyone than can tell me how to return the type of a column in a oracle database as a string in VB??

When every things go black,
scream, change the fuse and
start over!!
ARRGH!!

 

[Glasgow]

Are you using an ADO recordset. If so I would expect you could reference, e.g.

rs.fields("ClientName").Type

 

[AtleOlsen]

Thanks a lot! It seems to work, though I found a different way around it, selecting the datatype from user_tab_column table in oracle by table name and columnname ,but thanks anyway. (I think that is what VB does when using rs.Fields("ClientName").type

When every things go black,
scream, change the fuse and
start over!!
ARRGH!!