Obtaining Column Names Through GetOleDbSchemaTable

[Guest]

I'm currently obtaining the column names of my table (in an access database
file stored locally). However, upon receiving the list, all of the column
names have been sorted and are not in their original order. I was wondering
if this was a result of the method (and in that case if it's preventable) or
if it is a result of Access. Thanks.

 

[Mona]

Hi,

Regarding this issue, I would like to tell you that the data is coming to be
sorted and not in the original form because it might be possible that after
the data has been sorted it is saved to the database and when invoked again,
the sorted data appears.

Hope this helps.

Regards,
Mona [Grapecity]

 

[Guest]

Unfortunately, I have double checked the database currently being used and
this is not the case. The columns have not been rearranged and are still in
the same order. Yet, the results of the method continue to be sorted.

Hi,

Regarding this issue, I would like to tell you that the data is coming to be
sorted and not in the original form because it might be possible that after
the data has been sorted it is saved to the database and when invoked again,
the sorted data appears.

Hope this helps.

Regards,
Mona [Grapecity]

I'm currently obtaining the column names of my table (in an access database
file stored locally). However, upon receiving the list, all of the column
names have been sorted and are not in their original order. I was wondering
if this was a result of the method (and in that case if it's preventable) or
if it is a result of Access. Thanks.

 

[Paul Clement]

¤ I'm currently obtaining the column names of my table (in an access database
¤ file stored locally). However, upon receiving the list, all of the column
¤ names have been sorted and are not in their original order. I was wondering
¤ if this was a result of the method (and in that case if it's preventable) or
¤ if it is a result of Access. Thanks.

I believe it's an issue with the Jet OLEDB Provider. You can use the ORDINAL_POSITION value that is
returned for each column to determine the order in which each column appears in the table.


Paul
~~~~
Microsoft MVP (Visual Basic)