🚀 go-pugleaf

On Fri, 31 Oct 2003 10:30:34 -0500, Robert Emmons
<remmons@aurigen.com> wrote:

>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?

After further testing I have determined that the TDBGrid simply does
not display the table in order by any index.  I defined an an index on
ID1, another on ID2, another on Date.  The indexes appear as
selections in design mode, but order of the records in the TDBGrid
does not change regardless of which index I select.  The TDBGrid seems
to always show the table in the order that the records are actually
entered in the table.

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