Search code examples
sqliteqt4qt4.8qsqlquery

Retrieving row count from QSqlQuery, but got -1

I'm trying to get the row count of a QSqlQuery, the database driver is qsqlite

bool Database::runSQL(QSqlQueryModel *model, const QString & q)
{
    Q_ASSERT (model);

    model->setQuery(QSqlQuery(q, my_db));
    rowCount = model->query().size();
    return my_db.lastError().isValid();
}

The query here is a select query, but I still get -1;

If I use model->rowCount() I get only ones that got displayed, e.g 256, but select count(*) returns 120k results.

What's wrong about it?

Solution

  • The documentation says:

    Returns ... -1 if the size cannot be determined or if the database does not support reporting information about query sizes.

    SQLite indeed does not support this.

    Please note that caching 120k records is not very efficient (nobody will look at all those); you should somehow filter them to get the result down to a manageable size.