|
Local sort in TOracleDataSet
|
Joined: Aug 2004
Posts: 83 Ukraine
Member
|
OP
Member
Joined: Aug 2004
Posts: 83 Ukraine |
Hello! Will local sort on client (TOracleDataSet) make in latest versions DOA
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 1999
Posts: 22,221
Member
|
Member
Joined: Aug 1999
Posts: 22,221 |
The current version does not allow you to sort locally. Maybe we can add this in a future release.
Marco Kalter Allround Automations
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2004
Posts: 83 Ukraine
Member
|
OP
Member
Joined: Aug 2004
Posts: 83 Ukraine |
Hi! How about local sorting? ============================================== 30-Jun-04 New features in ODAC 5.10 - Local sorting ============================================== Wbr, Andrey
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Jul 2003
Posts: 112 Fino Mornasco, Como, Italy
Member
|
Member
Joined: Jul 2003
Posts: 112 Fino Mornasco, Como, Italy |
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.
LDS
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2004
Posts: 83 Ukraine
Member
|
OP
Member
Joined: Aug 2004
Posts: 83 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;
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Jun 2006
Posts: 27 Albania, Tirana
Member
|
Member
Joined: Jun 2006
Posts: 27 Albania, Tirana |
is there any workaround to bypass this without refetching records ? Will it soon be anything like toracledataset.sort property ?
regards Altin
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2004
Posts: 83 Ukraine
Member
|
OP
Member
Joined: Aug 2004
Posts: 83 Ukraine |
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Sep 2004
Posts: 29 Bordeaux (France)
Member
|
Member
Joined: Sep 2004
Posts: 29 Bordeaux (France) |
Hi, any news about local sort in DOA components without refetching records?
regards,
Zugg
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2009
Posts: 67
Member
|
Member
Joined: Aug 2009
Posts: 67 |
For developers: Please add support local sorting in DOA!
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2009
Posts: 67
Member
|
Member
Joined: Aug 2009
Posts: 67 |
to Marco Kalter: Are you add local sorting in DOA if I have Annual Service Contract?
Last edited by sinys; 04/05/12 06:55 AM.
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 1999
Posts: 22,221
Member
|
Member
Joined: Aug 1999
Posts: 22,221 |
That is not really what the Annual Service Contract is for
Marco Kalter Allround Automations
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2009
Posts: 67
Member
|
Member
Joined: Aug 2009
Posts: 67 |
This is a very important opportunity (local sorting in DOA) for us. Give me a hint how to make you to do it. :-)
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2004
Posts: 83 Ukraine
Member
|
OP
Member
Joined: Aug 2004
Posts: 83 Ukraine |
sinys, I buy Annual Service Contract for many years. But... No local sorting is still
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2009
Posts: 67
Member
|
Member
Joined: Aug 2009
Posts: 67 |
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2009
Posts: 67
Member
|
Member
Joined: Aug 2009
Posts: 67 |
[quote=Andrey Maximenko, Ukraine]sinys, I buy Annual Service Contract for many years. But... No local sorting is still [/quote]
Propose to keep the subject in the top until the problem is solved!
|
|
|
Re: Local sort in TOracleDataSet
|
Joined: Aug 2009
Posts: 67
Member
|
Member
Joined: Aug 2009
Posts: 67 |
|
|
|
|
|
|