I have made a very simple table in a SQL Database, containing a string field (col 1) and a nummeric field (col 2) (800 rows)
I connect to it via ADOConnection-->ADODataset-->Datasource
DBAdvgrid connects to the dataset.
By executing "Group(1)", the grouping will be incorrect. Only one row, regardsless that there are more different values of the column 1.
If I copy exactly the same values into a TADVStringGrid, everything works correctly.
How can I make the DBAdvGrid to work correctly when grouping?
Anders
Please set grid.PageMode = false, this is required to use the built-in grouping.
Oops - now another problem.
The DBAdvGrid actually contains a dataset which is a detals dataset related to a master.
If PageMode=True, then the (ungrouped) grid reflects the detail dataset correctly (when I in the Master dataset move the cursor from one row to another) - But it can then not be grouped
If PageMode=False, the DBAdvGrid groupes correctly if it is NOT a detail dataset (but just a plain dataset)
But if it is detail dataset now rows at all will show up (?)
Any suggestions?
I found the reason.
I need to call .Reload; after each move of the Master dataset.
Thanks