Custom sort order for dataset after executing query?

delphi sorting dataset delphi-2009 advantage-database-server
Heinrich Ulbricht picture Heinrich Ulbricht · Oct 26, 2011 · Viewed 7.3k times · Source

I want the result set of a database query to have a certain order. The information I want to order by is not contained in the database, but dynamically generated in code (so I cannot use ORDER BY).

Is there a way to sort a dataset after executing the database query? (I don't need indexed access but only want to iterate over all records.)

Answer

Arjen van der Spek picture Arjen van der Spek · Oct 26, 2011

With a ClientDataset you are able to change the order after executing. Settings IndexFieldNames sorts the dataset.

You can find information here how to connect a clientdataset to another dataset in the same application.

  object DataSetProvider1: TDataSetProvider
    DataSet = MyAdsQuery
    Left = 208
    Top = 88
  end
  object ClientDataSet1: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider1'
    Left = 296
    Top = 88
  end

Related questions

Sort DBGrid by clicking column's title

Well, this seems a little tricky (if not imposible). I'm trying to make my DBGrid sort its data by clicking on column's title. The thing is that I'm (sadly) working with Delphi 3, I'm not using ADO DataSets and the query …

Read More
How can I get TStringList to sort differently in Delphi

I have a simple TStringList. I do a TStringList.Sort on it. Then I notice that the underscore "_" sorts before the capital letter "A". This was in contrast to a third party package that was sorting the same text and …

Read More
How Can I Sort an ADO Table on a Fieldname Containing a Space?

I am using Delphi, but this is a simple and general problem: I'm doing the following: var ArticlesTable: TADOTable; begin ArticlesTable.DisableControls; ArticlesTable.Sort := 'CITY'; ArticlesTable.First; while not ArticlesTable.Eof do begin ... ArticlesTable.Next; end; This works very well …

Read More