[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Delphi, MS Access & Multiple Indexes

Posted on 2002-04-04
1
Medium Priority
?
235 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 200 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline
Suggested Courses

873 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