Hi TMS team,
I have a problem with the sorting in the TDBAdvGrid. Here is my setup. My grid is linked to a TMyDataSource (TMyQuery) and this query is sort by the "IndexFieldNames" property. My data are on a MySQL Server.
I take a look at the demo project "\TMS VCL UI Pack Demos\DBAdvGrid\CDSSort" and I want to use the bottom method to sort my query.
In the event "OnCanSort" of the grid, I change the "IndexFieldNames" of the query but the grid doesn't refresh. I try to add a "TMyQuery.First" and it doesn't work.
I add "grid.Reload" at the end of the event and it works.
But in the demo project, it don't need to add this code for the grid to sort.
Can you explain me why ?
Thanks