QSqlQueryModel data update

[psi]

I was under the impression that the model classes would monitor the data assigned to them, guess I was wrong. According to what you said, I would just have to use a timer and write something like this?

void timerEvent()(
{
mod->select();
}

void timerEvent()(
{
mod->select();
}

To copy to clipboard, switch view to plain text mode 

Do I need to set the model to refresh the view? Thank you.

ps. this is very strange..... the above code will actually erase the view (ie. the header columns) for some reason.

[wysota]

I was under the impression that the model classes would monitor the data assigned to them

In general - yes, but with databases it's simply impossible. The overhead for doing this is quite high.

According to what you said, I would just have to use a timer and write something like this?

void timerEvent()(
{
mod->select();
}

void timerEvent()(
{
mod->select();
}

To copy to clipboard, switch view to plain text mode 

Yes, something like that.

Do I need to set the model to refresh the view?

No, the model will tell the view to refresh itself.

ps. this is very strange..... the above code will actually erase the view (ie. the header columns) for some reason.

Yes. If you use select() you actually clear your model and populate it again, so the header data vanishes as well and you have to set it again. If you wish to avoid that, you have to avoid making a select() and compare and synchronise the model yourself, but it's slightly more work, so it's proabably easier to set the headers again. Note that you're likely to also loose any selection in the view.

[jcyangzh]

You should use setQuery.