Sort DBGrid by clicking column's title

delphi sorting dbgrid
Eliseo Ocampos picture Eliseo Ocampos · Jul 17, 2009 · Viewed 22.1k times · Source

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 gets a lot of rows, thus I can't reopen my TQuery changing the order by clause on clicks.

Someone has implemented something like this?

Answer

Mason Wheeler picture Mason Wheeler · Jul 18, 2009

This is actually done by sorting the dataset, and then the grid reflects the change. It can be done easily enough by creating an index on the dataset field for that column. Of course, this can only be done on a dataset that supports index sorting, such as TClientDataset.

Related questions

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
Sorting TDictionary by a key of Integer in ascending order

How can I sort TDictionary by a key of Integer in ascending order in Delphi 2009?

Read More