Solved

Delphi, MS Access & Multiple Indexes

Posted on 2002-04-04
1
225 Views
Last Modified: 2010-04-04
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
0
Comment
Question by:shaneholmes
1 Comment
 
LVL 44

Accepted Solution

by:
CrazyOne earned 50 total points
ID: 6919833
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Intraweb submit form as a POST request 4 259
Delphi: how to send PJL commands to printer 3 88
SUM 2 INTEGER ARRAYS INTO 1 10 93
Delphi...Split view - idea? 1 40
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now