DBAdvGrid columns not sorting when Table is used

Trying to allow Grid columns to be sorted where the dataset is a Table.  Works for fine for a Query but not a Table.  Not dealing with a lot of rows   Can Grid sort data already in the grid without a "SQL ORDER BY" query ? 


Can see the sort arrow showing in the column but no sort is performed when column header clicked.

Regards,

John

More information: To sort on a table PageMode = False. Doesnt work when table has a masterfield as part of linking two tables together.