Sorting by a column without index

Follow

shane richardson

• September 15, 2021 15:58

Hi there,

I'm using IP2007 and have a grid that I am trying to sort when I click on the titles. Currently the other columns use secondary indexes to sort by, however this column is generated from data from two other columns and doesn't exist in my database, but does in the grid. Without updating the databse or adding indexes, can I sort this column based off the values in my grid?

1

• 

  Roy Woll

  • September 17, 2021 04:39

  The sorting takes place in the dataset, not the grid.  So you would have to sort it by an index, or in the case of a query you would need to modify your query.  If your dataset is localized such as with a TClientDataSet, then you can sort using the IndexFieldNames property.

  0

  Comment actions Permalink

Please sign in to leave a comment.