Pagemode swiching

overes_boudewijn · November 7, 2015, 9:29pm

I am using MySQL as database.

In the TDBAdvGrid i what to sort and edit at the same time.

but i leaned:
Editing: PageMode must be TRUE
Sorting: PageMode must be FALSE (sorting by column header click)

How to combine both in a smooth why?

Now i try to toggle PageMode TRUE/FALSE by using the
TDBAdvGrid.onCanSort:
if GrdMyqHupEd.PageMode then GrdMyqHupEd.PageMode := false;

and the
TDBAdvGrid.onClickCell:
if not GrdMyqHupEd.PageMode then GrdMyqHupEd.PageMode := true;

But now the data in the grid refreshes / reorders in a wrong way.

What am i doing wrong?

brunofierens · November 7, 2015, 10:47pm

With grid.PageMode = true, perform the sort at dataset level as demonstrated in the TDBAdvGrid samples ADOSort / BDESort.