Hi! How about local sorting? ============================================== 30-Jun-04 New features in ODAC 5.10 - Local sorting ============================================== Wbr, Andrey
For local sorting to be useful the whole result set must be fetched. If I need it I can simply use a TClientDataset or a memory table. I do not know if a "do it all" component is the way to go - I think a set of smaller components each designed and optimized for a specific task is a better approach. I prefer the dataset + cds (or memory table) approach then an "overloaded" dataset.
Hi! It's very simple example for local sorting all records in desc order
Code
procedure TRecordDataList.DescSort;
var i : integer;
p : Pointer;
begin
for i := 0 to Self.Count div 2 do
begin
p := Self[i];
Self[i] := Self[Self.Count-1-i];
Self[Self.Count-1-i] := p;
end;
end;