p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

activex_data_objects thread: RE: Any way to find column's ordinal posit- ion?

Message #1 by Thomas Bellavia <TBellavia@V...> on Mon, 12 Nov 2001 10:12:29 -0500
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...

-----Original Message-----

From: Doug W. [mailto:nnnhack@y...]

Sent: Thursday, October 18, 2001 3:15 AM

To: ActiveX_Data_Objects

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..





  Return to Index