🚀 go-pugleaf

On Fri, 31 Oct 2003 11:36:35 -0500, "Arnie Mauer" <xxx@nowhere.net>
wrote:
>"Robert Emmons" <remmons@aurigen.com> wrote in message
>news:1vv4qvcl4irnt8ln5t1p31ge0cshk96s6s@4ax.com...
>>
>> DataSource->DataSet->Tbl->Active = true
>> DataSource->DataSet->Tbl->IndexName = PrimaryKey
>
>Shouldn't you set the IndexName before you activate the table?
>

Yes.  Sorry about the confusion.  First, I set Active=false.  Next, I
set the IndexName.  Finally, I set Active=true.  I did it all at
design time, not in code, so I could not set the IndexName at all if I
did not set Active=false first.

>
>An index does not guarantee the order of the returned rows.  This is defined
>in ANSI SQL.  Either use an ORDER BY clause on a query object or the SORT
>property of a table object.  From BCB Help:
>

ORDER BY applies to queries.  I am not displaying a query in the
TDBGrid.  I am displaying a TADOTable.  I do not see a SORT property
in the propeties list of the TADOTable object.  The table has an
IndexName property with a drop down list that shows all defined
indexes.  I choose an index.  I set Active=true, and the grid does not
show the table in order by the specified index. Instead, the table is
displayed in actual record order.

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