BorlandTalk.com

Khari Villela · Guest

cross post from delphi.database.desktop...

Im trying to use a multi-column index with access and Im having a heck of
a time convincing D7 and ADO to use it.

Here's my scenario

Master table
master_id

Detail Table
master_id
date

I have a master/detail relatationship set up between these tables. I would
LIKE the detail table to be displayed in reverse date order (newest dates
first).

I have setup the table in access to have an index called "activeIndex" on
master_id;date with date descending. When I try to use this in the
TADOTable component indexName column,
it says indexName "activeIndex" is not found. If I put just date as the
indexFields property, then I get a type mismatch (presumably because I
dont have master_id in there). If I
put master_id;date in the indexFields, then it works and runs fine, but
the table is sorted in ascending order. I have even tried putting a
Descending index on the date column -
no luck.

So, can this be done - if so what are the database settings and component
properties required to do this.

thanks

khariV