🚀 go-pugleaf

It's working now :)

thanks!



"J.Steinecker" wrote:

> 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!
> >
> >