I have to fetch some data from different database table and show in table view, the table view not contain all column from database but mixed from different data base table. I need to do the following.
- Fetch few column from table1.
- Fetch one cell from table2 and edit the data from table1(1 or 2 column).
- Display the edited data on table view.
- Update table1 on DB while user edit on table view.
- Update table view in particular time interval.
So should I use QAbstractItemModel
or SQL Model Classes like QSqlQueryModel, QSqlTableModel,QSqlRelationalTableModel
.Whcih one is more suited in my scenario.
I looked in documentation but seems minimal example.