QSqlTableModel::select()

Hi,
Im writing a small program that uses SQlite database. I ran into a small problem when i select rows from the table.

Code:

---

QSqlTableModel model;
    model.setTable("vlad");
    //model.setFilter("id >=500");
    model.select();
    int rows = model.rowCount(); //rows = 256

---

The problem is that it will select first 256 rows from the table regardless if I use the filter or not. My database table has at least 4000 rows, and I need a method to select ALL rows.

Thanks you

Hi, see QSqlQueryModel::fetchMore(). Qt is only loading a piece of data and will reload if necessary.

After a select the model doesn't load all rows from Database.

With SQLITE the QuerySize isn't available then you can use the code

Code:

---

while (model.canFetchMore())
{
    model.fetchMore();
}

---

Thank you Lykurg and mcosta for your advice. your help really works.

Here is my updated code and it works, Thanks A lot:)

Code:

---

QSqlTableModel model;
    model.setTable("vlad");
    model.select();
    while (model.canFetchMore())
    {
        model.fetchMore();
    }
    int rows = model.rowCount();
    QString outext = "row Count:" + QString::number(rows);
    qDebug() << outext;

---

:) :) :)

An advice: don't use fetchmore if not really necessary. If you want the rowcount use a simple QSqlQuery. Don't know your concept or what you want to achieve but fetchmore is needed in only a few cases.