🚀 go-pugleaf

Hi,

if you use a TQuery as DataSet you can search the SQL->Text AnsiString for
an ORDER BY.

If you cannot find an ORDER BY then you can append one with the
column->FieldName.
If you find an ORDER BY then you can do different ways. In case it is the
same column I change the sort order from ascending to descending or vice
versa. In the other case you can change the sort column.
After that I close and reopen the manipulated query to do the sorting.

You have to think about some problems. You can have comments in the SQL
statement what you have to take into consideration on searching for the
ORDER BY. If you use calculated fields in your query then you get the
gridname in the OnTitleClick event, but on which column is to sort?
So I provided a method to produce an additional list which makes a mapping
between gridcolumns and querycolumns.

HTH
Juergen

"Ola Eriksen" <ola@callcom.no> schrieb im Newsbeitrag
news:1103_1025773874@ola...
> Hello!
>
> A simple question I guess :)
>
> Can anyone help me with some code so that I can sort the TDBGrid by the
field the user selects.
> I've activated the OnTitleClilck event, but I've not managed to write a
code that works :(
>
> Thanks!
>
>