activex_data_objects thread: RE: Any way to find column's ordinal posit- ion?
Under ADOMD (multidimensional ADO) there is an ordinal property in the
position object created when an axis object is created. Although, this is an
advanced form of database querying. Also, if you create a 'cell' object, an
ordinal property will be created as well.
Hope this points you in the right direction...
From: Doug W. [mailto:nnnhack@y...]
Sent: Thursday, October 18, 2001 3:15 AM
Subject: [activex_data_objects] Any way to find column's ordinal
Does anyone know of a way (via ADO or ADOX), besides using the
connection's schema, to find the ordinal position of a field?
Right now, I'm looping through every record of the recordset created
by the OpenSchema(adSchemaColumns) method of a connection, dumping the
ORDINAL_POSITION field into an array, and it's not working out very well...
I looked through the properties of an ADOX catalog, but didnt
find anything there... The Database I'm using is in Jet/Access...
Any help would be greatly appreciated..