use in-memory sqlite in QT

Asked Jun 08 '18 at 14:37

Active Jun 08 '18 at 14:37

Viewed 862 times

I created a QSqlQuery to get some value from an in-memory database, which been set by

setDatabaseName(":memory:")

When I execute the query, it gives me a QSqlError

QSqlError("", "Unable to fetch row", "No query")

However, when I change the database to be a file database by simply just set name to be "test.sqlite" for example, the query works perfectly without any changes.

Does anyone have any idea why this situation happened? Are there are any difference I need to know to set the query for in-memory database?

asked Jun 08 '18 at 14:37

Jason Lei

Are you creating the tables when using the in-memory database? – Mike Jun 08 '18 at 14:41
1

provide a [mcve] – eyllanesc Jun 08 '18 at 15:33
I do create the tables. Every operation works fine in C++ class, it just cannot be used in qml. – Jason Lei Jun 08 '18 at 19:35
Please provide a minimal and complete example of a `.qml` file that reproduces the issue. Since you say that every operation fails, you only need to show one operation. You're probably doing something wrong, but how can we knwo? – Kuba hasn't forgotten Monica Jun 11 '18 at 20:51

use in-memory sqlite in QT

0 Answers0