Adding Columns to a QSqlProxyModel

[cardfour1]

Hi All,

I've searched through several articles on how to add extra columns to a QSqlProxyModel, but none of them do a good job explaining how this could be done ( or done cleanly ).

Here's my question:

I have a simple QSqlModelProxy that has 4 columns. I want to generate a 5 column on the fly that is function of columns 2 and 3. I do not want this extra column saved in the database, what is the best way to implement this ?

Here's what I've tried:
I created an new with the class XProxyModel that inherits from QIdentityProxyModel. This class overloads the columnCount() method and returns the desired number of columns (5 ). I also overloaded the headerData method to catch the new columns and emit the proper Header strings. This all seems to work fine, my one problem is in the data method ( which I also overloaded in XProxyModel ), within this method my new columns
never show up through the QModelIndex, it stops at the true underlying columns.

What am I doing wrong ?

My other alternative is to change from a TableView to a TableWidget and manually populate this table through
a QSqlTableModel/QSqlQuery, is this the right solution ?

Thanks in advance.

[cardfour1]

I Believe I figured it out. If I had to overload the index method as well to return a proper QModelIndex , does this make sense ? Once I did this the row and column became visible through the data method.

[SGaist]

Hi and welcome to devnet,

Yes it does since you have to somehow provide indexes to access your "virtual" column