You must set the background after the select!

Reading from the database with select destroys the previously read data (== indexes) and inserts new ones.

Dear Volker!

You mean this?

I’m sorry, but it doesnt work

If you mean something else will you please show me some simple example?

I doubt it is going to work at all, but I may be mistaken.
To me, it sounds strange to set data on a QSqlTableModel that will not and can not actually be stored in the underlying data store. At least; I assume your database does not actually store the color, does it?

Still, perhaps QSqlTableModel is intelligent enough to cache this data for you.

MasterMatrix, it’s possible that the SQL models use lazy loading and the model is still not filled when you set the background.

Better way to achieve your goal would be to subclass QStyledItemDelegate [doc.qt.nokia.com], reimplement the paint method, set the background there and call the base class’ implementation for the rest.

Or create a Proxy model, only overwrite the data method and there change the color.

Gerolf wrote:

Or create a Proxy model, only overwrite the data method and there change the color.

That’s even better!

I use the last way too. I like the separation of concerns that you get here:

• base model contains the actual data
• proxy model handles decorating the data, such as changing colors
• view handles actual displaying of the data

I think I have a proxy model lying around somewhere that can be used for this. If I find it, I’ll let you know. I think it was limited to table-like base models (no trees), but that should not matter as the base model was not a tree anyway.

You could just use the QSortFilterProxyModel and overwrite the data method. No need to create a complete custom proxy model which handles persistent model indexes and all that stuff…

Of course. QSFPM is a proxy model as well, right?
If you need a complicated proxy model, depends on what you want to achieve exactly. If you want to color a complete row or column, then that is easy to do with QSFPM. If you want to be able to manually color cells, you need a bit more than that.