Solved

Delphi, MS Access & Multiple Indexes

Posted on 2002-04-04
1
224 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 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

12 Experts available now in Live!

Get 1:1 Help Now