Local sort in TOracleDataSet

[Andrey Maximenko. Ukraine]

Hello!
Will local sort on client (TOracleDataSet) make in latest versions DOA

 

[Marco Kalter]

The current version does not allow you to sort locally. Maybe we can add this in a future release.

 

[Andrey Maximenko. Ukraine]

Hi!
How about local sorting?
==============================================
30-Jun-04 New features in ODAC 5.10
- Local sorting
==============================================
Wbr, Andrey

 

[ldsandon]

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.

 

[Andrey Maximenko. Ukraine]

Hi!
It's very simple example for local sorting all records in desc order

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;

 

[altink]

is there any workaround to bypass this without refetching records ?
Will it soon be anything like toracledataset.sort property ?

regards
Altin

 

[Andrey Maximenko. Ukraine]

up

 

[Zugg]

Hi, any news about local sort in DOA components without refetching records?

regards,

Zugg

 

[sinys]

For developers:
Please add support local sorting in DOA!

 

[sinys]

to Marco Kalter:
Are you add local sorting in DOA if I have Annual Service Contract?

 

[Marco Kalter]

That is not really what the Annual Service Contract is for

 

[sinys]

This is a very important opportunity (local sorting in DOA) for us. Give me a hint how to make you to do it.

 

[Andrey Maximenko. Ukraine]

sinys, I buy Annual Service Contract for many years. But... No local sorting is still

 

[sinys]

outrage

 

[sinys]

sinys, I buy Annual Service Contract for many years. But... No local sorting is still

Propose to keep the subject in the top until the problem is solved!

 

[sinys]

up!