How to fill an inserted column with data?

[wysota]

You can't insert columns into the database like that. insertColumn() may even work but the QSqlRecord that operates on the data in the model knows nothing of your new column so it can't return data for it. It's even probably setData() returns false denoting that the operation has failed.

[croo]

I rechecked and setData() returns true.
My goal is to make a computed column of something related to that database and display it.
I'm not at all trying to modify the underlying database..

My plan was to load the desired table from the database to a model, display it, then add one more column to the model, and fill it with whatever I want(it was like this in ado.Net). Your reply suggest that there is a stronger connection between the db and the model.
I recently started to learn the model/view part of Qt and probably went the wrong way....

So how can I do something like this?

[wysota]

I rechecked and setData() returns true.
My goal is to make a computed column of something related to that database and display it.
I'm not at all trying to modify the underlying database..

So either subclass the model or implement a proxy model for your database model. A cleaner approach would be to use a proxy although it's probably a bit (just a bit) more work.