Hi all

I'm having a bit of trouble with my VB6 app which uses DAO to connect to an Oracle database via ODBC. The app is basically a data manipulation tool, it takes data from a source database and converts it into different formats for several destination databases.

The problem is : at one point in the app I need to find the type (date, string, number etc) of a field in a row in a recordset.

I have tried using field.type and also typename(field.value). Both of these things work correctly for dates and strings, but when I try a field which is defined as a number in the Oracle database, both commands say it's a string. When I 'watch' the field, it's type property actually says 'variant/string'.

So my question is : is there a way of correctly getting the field type?

(I can't use IsNumeric because the details about the fields I'm manipulating are stored in the database too, and there are other fields which are defined as varchars but might only contain numeric data).

If anyone knows, please tell me!! Either on this group or at [email protected]

Thanks
Colin