Direct local sorting of a data set

Yevgeny · Post by **Yevgeny** » Tue 21 Dec 2004 11:18

Hi,

We're working with the local sorting option of TCRDBGrig (ODAC Net 5.10.2.8 for Delphi 7).
When sorting locally, what is actually sorted is a data set component (in my case TOraStoredProc) related to a data source component assigned to the grid.
Often we fetch data from the database without showing it in the grid (without using TCRDBGrid and TOraDataSource components).
How can we sort data sets locally and directly (without using TCRDBGrid features) ?

Thanks,
Yevgeny

Alex · Post by **Alex** » Thu 23 Dec 2004 08:18

You can use IndexFieldNames property with all descendants of TMemDataSet to process ordering locally. If you need to know more about this feature pls. see ODAC help: TMemDataSet.IndexFieldNames topic.

andrekh · Post by **andrekh** » Tue 18 Jan 2005 10:43

eventsQuery := TOraQuery.Create(Self);
eventsQuery.IndexFieldNames = 'test;tist1';

error: Endeclared identifier: "IndexFieldNames"

Alex · Post by **Alex** » Tue 18 Jan 2005 12:16

What version of ODAC do you use? Local sorting ability using TMemDataSet.IndexFieldNames added since 5.10.0.5.
If you have newer ODAC version pls. send us small demo project that demonstrates your problem to ODAC support address.