How to get a QModelIndex from another QSqlQuery used for searching the database (needed for selecting the found items)

Question

Hi there,

I have a problem when dealing with my QSqlQueryModel. I want to search the database for some items and select them in my QTableView with QItemSelectionModel which needs a QModelIndex.

What I don't understand is how should I search in order to get the corresponding QModelIndex for my model/view architecture. I can't possibly use the model itself, because it would mess up the items shown in the view. So a QSqlQuery or an extra QSqlQueryModel would maybe be an option, but how is it possible to translate from their result-index (.at()?) to a QModelIndex which fits to my Model/View-System...

Thanks in advance!

Answer 1

The easiest way is to take a look at QSQLQueryModel, and set your TableView's model to it.

http://doc.qt.nokia.com/4.5/qsqlquerymodel.html