BUG: SQLStatistics Always Reports Indexes as Ascending

MORE INFORMATION

You can specify an index either as ascending or descending using the ODBC SQL grammar. The syntax is:

   CREATE [UNIQUE] INDEX index-name ON base-table-name
   (column-identifier [ASC | DESC]  [,column-identifier [ASC | DESC]...)
				

SQLStatistics is an ODBC API function that retrieves a list of statistics about a single table and the indexes associated with the table. It returns the information as a result set whose seventh column is the index type. It returns "A" for ascending and "D" for descending index types. However, the dBase, Access, and FoxPro drivers return "A" for the index type when the index is created as descending.