How to make local sort with ODAC

[ozzy]

example please Delphi or BCB

[Plash]

To perform local sorting of data in TOraQuery or TOraTable components assign to IndexFieldNames property the list of field names by which the recordset has to be sorted. For example:

Code: Select all

OraTable.IndexFieldNames := 'JOB;SAL';

See description of IndexFieldNames property in ODAC help for details.