GetSchema - need Columns in Ordinal Position

  • Thread starter Thread starter Algonquin J. Calhoun
  • Start date Start date
A

Algonquin J. Calhoun

Hello All,

I'm writing a small utility to assist my coding when using access tables. In this phase, I want to get the schema columns when creating a datatable
of columns and attributes using the statement:

dtc = cn.GetSchema("Columns", dtcRest)

I retrieve all the columns OK, but I want them to be in ORDINAL_POSITION (a column in the resulting table) sequence. I've tried everything I could
think of (ORDER BY), but just can't get it.

Now its time to try something that others have thought of.

Need some help.

Thanks,

Al
 
For Access (JET) tables, many of the field properties can be read only
through DAO.

Here's an example of how to enumerate the fields of a table in order:
http://allenbrowne.com/func-06.html

If you need it, fields also have an OrdinalPosition property exposted via
DAO.
 
Back
Top