QSqlTableModel::select()

[vladozar]

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

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

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

To copy to clipboard, switch view to plain text mode 

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

[Lykurg]

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

[mcosta]

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

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

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

To copy to clipboard, switch view to plain text mode 

[vladozar]

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

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

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;

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;

To copy to clipboard, switch view to plain text mode 

[Lykurg]

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.