TADOTable Out of Order

Article View: borland.public.cppbuilder.database.ado

Article #2167

Back to borland.public.cppbuilder.database.ado Previous Next

#2167

From: Robert Emmons
Date: Fri, 31 Oct 2003 15:30

18 lines
1344 bytes

I have a TADOTable (Tbl) in a Jet database with the following fields:

ID1
Date
ID2
Data

The PrimaryKey is ID1, Date, ID2.  I display the table in a TDBGrid,
and set:

DataSource->DataSet->Tbl->Active = true
DataSource->DataSet->Tbl->IndexName = PrimaryKey

Nevertheless, the table appears in order by ID1, ID2, Date instead of
by ID1, Date, ID2.  If I display the table with Microsoft Access, it
appears properly in PrimaryKey order.

How can I get the table to appear in proper order in the TDBGrid?

Technical Details

Message-ID: <1vv4qvcl4irnt8ln5t1p31ge0cshk96s6s@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b4ab9cb102f7ab18,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-10-31 07:34:22 PST
From: Robert Emmons <remmons@aurigen.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TADOTable Out of Order
Date: Fri, 31 Oct 2003 10:30:34 -0500
Message-ID: <1vv4qvcl4irnt8ln5t1p31ge0cshk96s6s@4ax.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 68.193.14.50
X-Trace: newsgroups.borland.com 1067614222 68.193.14.50 (31 Oct 2003 07:30:22 -0700)
Lines: 19
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail