I am using a TDBAdvGrid with Pagemode = FALSE.
I perform my OWN CUSTOM sorting by sorting the clientdataset to which it is connected according to user selection - row two has a check box for each column so that the user can click any number of checks in the column and then the data is sorted using each field, in the order in which it is clicked.
When i have the pagemode false, the grid does display my sort. if I set it to TRUE, then my sorting works fine.
I want pagemode off because with pagemode on, I get nasty flicker and sometimes large amounts of blank rows which dont display data. I also dont want to go back to the database for each sort operation - should be localised to the PC to avoid excessive traffic
Any help / ideas?