Sorting

hi
i have a cds which data is filled in runtime, not using a SQL
but a simple cds.Append; and cds.Post;

how can i make a column order when the user clicks on the header?
i cant simply use order by or sth like that
all records are buffered

thanks

Hi emailaya!

I prefer Firebird + FIBPlus components. TpFIBDataSet supports ordering by multiple fileds on buffered records either. I don't think that NextDBGrid can order rows, because rows aren't buffered, but you may try with buffering options included. If you don't need on the fly editing behaviour you may try NextGrid + NxDataCellSource component. I had cases where this solution worked best, but I'm not an expert of NextGrid.