Keep data in QSqlQueryModel when server is offline

[Tottish]

Thank you for replying but I'm not sure I'm following.
I don't think there is a method called QSqlQueryModel::select and if there is I can't find it.

Could you try to explain in more detail how I would go about saving my query in a QAbstractTableModel?

If anyone else have other opinions on how this should best be preformed, all input is welcome.

Thanks!
/Tottish

[mcosta]

I don't think there is a method called QSqlQueryModel::select and if there is I can't find it.

Sorry, I means QSqlTableModel::select()

However, when you have QSqlTableModel/QSqlQueryModel you can navigate it and add a row in your QAbstractTableModel for each record in QSqlxxModel

[Tottish]

Ah, I think I see now, but wouldn't such an operation be really expensive if the table has a couple of hundred rows and say 25 columns (as it is in my case)?
How fast would the interaction be with such a table compared to creating a SQLite table and "copy" the retrived query into that?
Anyway, I'll check it out!
Thanks for the tip!
/Tottish

[mcosta]

Using "in memory" model (I think) is faster than using a "file-system" model (like SQLITE). You can also create an "in memory" SQLITE database.
Depends from the "size" of the data that you retrieve

[Tottish]

OK mcosta, I'll go with the in memory model then. The data shouldn't be very bulky.
Thanks a lot!
/Tottish