Devart Forums

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

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.

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

error: Endeclared identifier: "IndexFieldNames"

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.