Wrox Home  
Search P2P Archive for: Go

  Return to Index  

activex_data_objects thread: Any way to find column's ordinal position?


Message #1 by "Doug W." <nnnhack@y...> on Thu, 18 Oct 2001 07:15:19
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..



Thanks,

--Doug


  Return to Index