Qt – How to add calculated column in QsqlRelationalTableModel ?

Question

I have an table view showed

part description, quantity, price

And I have a Model/View using this code

model = new QSqlRelationalTableModel(this);
model->setTable("parts");
model->setRelation(3,QSqlRelation("part_tbl","part_id","part_desc"));

model->select();
ui->tableView->setModel(model);

I need to add a new column that shows quantity * price in the table view. It's important to know I'm using QsqlRelationalTableModel

Help is appreciated, Thanks in advance

Answer 1

I think your best bet for handling this is to make either a model that inherits QSqlRelationalTableModel, or one that acts as a proxy (and contains a member for the model). Your new model will add the extra column, and when the data is requested for that column, use the data from the other columns to compute what is required.