You are using not more than 1 table so QSqlTableModel fits your needs?Qt Code:
model->setQuery( "SELECT field1,field2 FROM table1" );To copy to clipboard, switch view to plain text mode
instead of
QSqlQueryModel *model = new QSqlQueryModel(tableView);
you could use
QSqlTableModel *model = new QSqlTableModel(tableView);
which has
void QSqlTableModel::sort ( int column, Qt::SortOrder order ) [virtual]
implemented
Cheers
Bookmarks