QSqlTableModel and QTableView and sorting

[JeanC]

Hello,

I have setSortingEnabled (true) for this table so that when I click on a column header, the table gets sorted to that column. Very nice.

But in combination with setFilter() the sorting order is not always the same. The order of records is different if a filter is applied.

There are columns with the same value, and in a normal sql case you would then use an 'order by' with 2 arguments, 'order by thisfirst, thatsecond' which would get around such problems. I suspect this is the reason why the order differs when I set a filter.

Trying to illustrate:

Name Type Age (sorted on column Age)
a 1 1
b 1 1
c 2 1

setFilter(type = 1)

b 1 1
a 1 1

Should be a first, then b.

Hope I am being a bit clear. Thanks.