Sorting columns of the QTableView

[Qiieha]

Ok, thank u for your help, but I want to use the setQuery method. And if I use QSqlTableModel this Method isn't available(protected). And the documentation say, that setQuery shouldn't be used.

Do you know a solution?

[MarekR22]

Which setQuery do you use? Note that void QSqlQueryModel::setQuery(const QString &query, const QSqlDatabase &db = QSqlDatabase()) is still public, only void QSqlQueryModel::setQuery(const QSqlQuery &query) is protected.

[Qiieha]

Unfortunately QSqlTableModel has only one setQuery() method and it is this one: QSqlQueryModel::setQuery(const QSqlQuery &query).

What can I do?

[MarekR22]

Nope! You are wrong!
QSqlTableModel inharits form QSqlQueryModel. One version of setQuery is repated in QSqlTableModel to make it protected for some reason. Second version is still public and you can and should use it.

[Qiieha]

I tried to make that and know that there are two versions, but the compiler doesn't offer the possibility to use it

[Qiieha]

Does anybody know why???

[spawn9997]

This has been asked a lot and it seems there is no easy or direct answer. HERE

It seems implementing your own model is the best bet. I prefer sorting via proxy (QSortFilterProxyModel) but DB access speed can make large models sort slowly.

spawn9997