Delphi, MS Access & Multiple Indexes

I have a Delphi App using ADO and MS ACCESS. In the MS ACCESS DB, I created a table which has a multifield index (two fields).

I was wondering how I get the two fields to index in my Delphi Application. It is only indexing on the first of the two fields.

IELite
LVL 11
shaneholmesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
CrazyOneConnect With a Mentor Commented:
I don't know which ADO components you are using. I am using DearSoft and it has a "Sort" property. I built a table with these field names

a  b  c  d  e  f  g

I enter data so I had 5 records. I then went to the "Sort" properties of the ADO Table component and entered this

b,c

and the results where sorted appropriately for my test.



The Crazy One
0
All Courses

From novice to tech pro — start learning today.