Sorting DBAdvGrid with FIBDataSet by clicking on column header
The only solution to the above problem I have found is to bind the "ORDER BY" statement to the SQL FIBDataSet query. It looks weird because the Grid has its quicksort () implementation, but I can't get it to work. Any ideas would be appreciated.
The commonnly grid sorting method does "in-memory-sort".
If you are using Devrace FibPlus, then there is TpFibDataset which inherits from TFibDataset which has built-in implementation of SQL parsing and ORDER BY.