Getting the Field Information

M

mhsueh001

Active member
Joined
Dec 31, 1969
Messages
41
In the old version of ADO you could get the field information about the table that the recordset was linked to.

How do I get the field information for a table through a dataset?

Ive been searhing and cant find it.

Im creating an import program and would like to verify that.

1. The data in the list is of the proper type (without having to hard code it in)

2. Verify that the string length does not exceed what the field length is set by the table.

I would like to do this before the insertion rather than trapping an error and figuring out what to do afterwards.

Thanks
 
Oh and Ive looked in the Columns Collection and they have a MaxLength Property. But this is set at -1?

Any clues?
 
Back
Top