Left join on to models



  • hi,

    I have search on a lot of qt sites/forums. But i can not find the solution how to to join 2 QSqlTableModels together.

    The models x and y can an be joined on x.nr and y.nr. table y contains extra information so i want to use a Left join. If the is for some reason no extra information the row form x is still displayed. The result needs to be a models so i can view it with a QTableView.

    On several places i read that i need to subclass QAbstractProxyModel. But how? which function need to be reimplemented?

    Does someone has an example?



  • Can mentioned join be achieved by sql query? If yes then instead of implementing filtering model (QAbstractProxyModel) try to set appropriate sql query for your QSqlTableModel (see 'setQuery' methods).



  • Model x is a model with data that is not committed to the database. So a join in the database cant be done. Table y contains extra information for each row from table x.


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.