Find out data types maybe?

[Criki]

OK, so I'm using this OpenSchema thing that I just found out about and love but now I'm trying to find out how I can determine the data type of a specific field.

Can you do this through OpenSchema?

[Jethro]

Whats OpenSchema?

[honeybee]

Originally posted by Criki
OK, so I'm using this OpenSchema thing that I just found out about and love but now I'm trying to find out how I can determine the data type of a specific field.

Can you do this through OpenSchema?

You can do it in DAO, maybe in ADO, too. Since I don't have any ADO knowledge, I can't give opinion on that, but DAO has a property, Type, for the field object which can tell the data type of the field.

.

[Criki]

Unfortunately, I have no knowledge of DAO.

Example of OpenSchema...

Set rs = cn.OpenSchema(adSchemaTables, Array(Empty, Empty, Empty, "TABLE"))

Returns all the Table Names in the database.

[Jethro]

Well there you go, didn't know that Thanks Criki

Honeybee is right though, In DAO you can extract all details from a recordset. We have this running on ourt major product, cause it hooks databases up to a data mining thing, and hence doesn't know what is in a table.

I didn't write the code, just suggested that this would be a great function, but could get some one to send me the module or whatever that does it. Apparently is not too complicated, but is a bit undocumented by MS.

[Criki]

It was really just an extra bell to add in.
Not to worry.

But thank you both.