QSqlTableModel::insertRows, using the row parameter

[Ashkan_s]

Hello

I have a QTableView with a QSqlTableModel as its model.

The problem is that the newly added rows will be displayed at the end of the view, no matter what is the value of row.

Documentation of QSqlTableModel::insertRows says: "Inserts count empty rows at position row." and in QAbstractItemModel::insertRows it says: "inserts count rows into the model before the given row."

If "into the model" means it has no predicted effect on the view, what's the use of row?

[ChrisW67]

The function does exactly what it says it does. The view may be sorting the rows, you may be using an invalid row number etc. We don't know unless you can provide a small example that demonstrates the problem. This, for example, works fine:

#include <QtGui>
#include <QtSql>
#include <QDebug>
 
void createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(":memory:");
    if (db.open()) {
        QSqlQuery query;
        query.exec("create table person (id int, "
                   "firstname varchar(20), lastname varchar(20), primary key(firstname, lastname))");
        query.exec("insert into person values(101, 'Danny', 'Young')");
        query.exec("insert into person values(102, 'Christine', 'Holand')");
        query.exec("insert into person values(103, 'Lars', 'Gordon')");
        query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
        query.exec("insert into person values(105, 'Maria', 'Papadopoulos')");
    }
}
 
int main(int argc, char *argv[])
{
    QApplication app(argc, argv);
    createConnection();
 
    QSqlTableModel model;
    model.setTable("person");
    model.setEditStrategy(QSqlTableModel::OnManualSubmit);
    model.select();
 
    QTableView view;
    view.setModel(&model);
    view.resize(640, 480);
    view.show();
 
    model.insertRow(2);
    model.insertRow(5);
 
    return app.exec();
}

#include <QtGui>
#include <QtSql>
#include <QDebug>

void createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(":memory:");
    if (db.open()) {
        QSqlQuery query;
        query.exec("create table person (id int, "
                   "firstname varchar(20), lastname varchar(20), primary key(firstname, lastname))");
        query.exec("insert into person values(101, 'Danny', 'Young')");
        query.exec("insert into person values(102, 'Christine', 'Holand')");
        query.exec("insert into person values(103, 'Lars', 'Gordon')");
        query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
        query.exec("insert into person values(105, 'Maria', 'Papadopoulos')");
    }
}

int main(int argc, char *argv[])
{
    QApplication app(argc, argv);
    createConnection();

    QSqlTableModel model;
    model.setTable("person");
    model.setEditStrategy(QSqlTableModel::OnManualSubmit);
    model.select();

    QTableView view;
    view.setModel(&model);
    view.resize(640, 480);
    view.show();

    model.insertRow(2);
    model.insertRow(5);
    
    return app.exec();
}

To copy to clipboard, switch view to plain text mode 

If you use the other edit strategies then you can only insert one row at a time (see QSqlTableModel::insertRows()) .