Tim,

The drop down list for the IndexFieldNames property of the TEDBTable does not include
indexes that are indexed on descending fields.

For example:

CREATE INDEX "ordDateDescIND" ON "Order" ("ContactID" DESC, "OrderDate" DESC);
CREATE INDEX "ordContactDescIND" ON "Order" ("ContactID" DESC);

The indexes ordDateDescIND and ordContactDescIND are in the drop down list for the
IndexName property, but there are no corresponding entries in the drop down list for the
IndexFieldNames property.

Is this how it is suppose to work?

--
Richard Harding
Windella Computer Knowhow
28 Freeman Drive
Lochinvar NSW 2321
Phone:   61 2 4930 7336
Mobile:   0419 016 032
email:   rharding@wck.com.au

Richard,

<< The drop down list for the IndexFieldNames property of the TEDBTable does
not include indexes that are indexed on descending fields. >>

Yeah, this is a stupid limitation of the way the standard TIndexDefs works.
We were able to workaround it with DBISAM 4.x due to the fact that we used
our own TDBISAMIndexDefs, but we can't do so with the TIndexDefs.

--
Tim Young
Elevate Software
www.elevatesoft.com