Hi!
I'm building an application which relies heavily on communication with external MySQL databases.
I haven't really discovered until recently that the query set in the model has to be open in order to provide the data to the model.
This means (to the user) that also the connection to the DBMS will have to be up for the table to display the data from the last query.
I've read the docs on QSqlQuery but I must say that I'm really not quite clear on why it has to stay open to stay valid, I mean it doesn't automatically update or anything, right?
Any way, what I would like to do is for the table in my user interface would keep the data even if the internet/DBMS-connection gets lost.
I guess one way would be to transfer the data that is to be shown to a temporary, local SQLite table but that sounds a little bulky and I'm guessing that shouldn't be necessary?
Thanks!
/Totte
Bookmarks