CODEWITHSUNDEEP
c++sqlqtsqlite
vas3k
vas3k

Reputation: 198

Select from SQLite with Qt

I try to deal with SQLite database on Qt 4.5.3 on Linux. I've already created the databsae.

Then, I try to perform select on Qt:

db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(filename); // Here is FULL path to the database. I've checked it twice :)
bool ok = db.open();
qDebug() << db.tables();

QSqlQuery query;
query.exec("select * from lessons");
qDebug() << query.size();
qDebug() << query.isSelect();
qDebug() << query.isValid();

But debug console says:

("lessons", "weeklessons", "weeks") 
-1 
true 
false

Why it's select nothing? What I have doing wrong?

Upvotes: 6

Views: 24000

Answers (5)

poke
poke

Reputation: 388443

Without knowing much about Qt, I was asking myself one question: How does the QSqlQuery know which connection to use. Looking that up in the manual revealed that there are basically two possibilities to execute a query:

  1. query = db.exec("select * from lessons");
    Using the database connection, and executing from there.
  2. QSqlQuery query( db );
    Constructing the query using the existing database and then executing the query:
    query.exec("select * from lessons");

edit: After reading a bit more, it seems that default connections are supported, so your example should work…

Could you try passing the query as the constructor's value instead? Maybe it works then.

QSqlQuery query("select * from lessons");

Upvotes: 0

Leiaz
Leiaz

Reputation: 2917

The isValid() method returns true if the query is positionned on a valid record, but after calling exec(), it isn't : you have to move to a valid record first, for example with query.first() or query.next(). See Qt docs : http://doc.qt.io/archives/4.6/qsqlquery.html

The size() returning -1 doesn't mean there is no result : SQLite is one of the databases for which the size of the query is not directly available (look in the documentation for QSqlDriver::hasFeature()). You can check that rows are returned and find the size with a loop and query.next().

Depending on what you want to do with the result of your select, you could also use QSqlQueryModel instead of QSqlQuery.

Upvotes: 9

DeDe
DeDe

Reputation: 1

This can give you a answer: http://www.qtcentre.org/threads/7904-Is-there-any-other-reason-why-QSqlQuery-size%28%29-returns-1

Upvotes: 0

Ton van den Heuvel
Ton van den Heuvel

Reputation: 10558

Given that your program reports that the query is invalid, have a look at the error message as follows:

QDebug() << query.lastError().text();

This should help you in debugging the problem.

Upvotes: 1

matt_man22
matt_man22

Reputation: 31

In your "QSqlQuery query;" declaration, you have to specify the database connection, e.g. "QSqlQuery query(db)"

Upvotes: 3

Related Questions