QSqlTableModel

[raphaelf]

Hi everybody,
I am searching examples how to use insertRow(); removeRow(); and updateRowInTable();
Can i find somewhere examples?
for display a table i havent problem. But how to construct and use insertRow(); removeRow(); and updateRowInTable();

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
        model->select();
 
 
        ui.tableView->setModel(model);
        ui.tableView->show();

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
        model->select();
        

        ui.tableView->setModel(model);
        ui.tableView->show();

To copy to clipboard, switch view to plain text mode 

If somebody have some finish examples why not

Thanks again

[wysota]

Hmm... what exactly you don't know? In case of SQL models, insertRow() does an INSERT call and removeRow() does a DELETE call. Guess what the third method does

[raphaelf]

Hi wysota,
I know what should do insertRow(); removeRow(); and updateRowInTable();
But i dont know how to use it.

With this code i am able to view the values of my table:

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
        model->select();
 
 
        ui.tableView->setModel(model);
        ui.tableView->show();

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
        model->select();
        

        ui.tableView->setModel(model);
        ui.tableView->show();

To copy to clipboard, switch view to plain text mode 

And now i would like to insert a new Row or update a value or delete a Row.
And my problem is:
How to use:
bool QAbstractItemModel::insertRow ( int row, const QModelIndex & parent = QModelIndex() )
bool QAbstractItemModel::removeRow ( int row, const QModelIndex & parent = QModelIndex() )
I have not found any examples how to use it.
In the passt i use this for create a new row:

QSqlQuery insert("insert into.....");
insert.exec()..
..

QSqlQuery insert("insert into.....");
insert.exec()..
..

To copy to clipboard, switch view to plain text mode 

I would like to use :

bool QAbstractItemModel::insertRow ( int row, const QModelIndex & parent = QModelIndex() )
bool QAbstractItemModel::removeRow ( int row, const QModelIndex & parent = QModelIndex() )

bool QAbstractItemModel::insertRow ( int row, const QModelIndex & parent = QModelIndex() )
bool QAbstractItemModel::removeRow ( int row, const QModelIndex & parent = QModelIndex() )

To copy to clipboard, switch view to plain text mode 

Can somebody show me how to use it?

[wysota]

model->insertRow(-1, QModelIndex());
model->setData(model->index(model->rowCount()-1, 0), "somedata");

model->insertRow(-1, QModelIndex());
model->setData(model->index(model->rowCount()-1, 0), "somedata");

To copy to clipboard, switch view to plain text mode 

But it's better to do it this way:

QSqlRecord rec = model->record();
rec.setValue("name", "John Doe");
rec.setValue("age", 18);
model->insertRecord(-1, rec);

QSqlRecord rec = model->record();
rec.setValue("name", "John Doe");
rec.setValue("age", 18);
model->insertRecord(-1, rec);

To copy to clipboard, switch view to plain text mode 

[raphaelf]

Hi wysota
It works
Thanks to open my mind! I am allways happy when i have the possibility to stude some examples
For insert new Values:

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
        model->select();
 
    QSqlRecord rec = model->record();
    ui.tableView->setModel(model);
    ui.tableView->show();
 
//I have auto increment at this table, so i dont have to give the new id
 
rec.setValue("status", "test");
    model->insertRecord(-1, rec);

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
        model->select();
    
    QSqlRecord rec = model->record();
    ui.tableView->setModel(model);
    ui.tableView->show();

//I have auto increment at this table, so i dont have to give the new id

rec.setValue("status", "test");
    model->insertRecord(-1, rec);

To copy to clipboard, switch view to plain text mode 

For Update a Value it works now like this:

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
        model->select();
        ui.tableView->setModel(model);
        ui.tableView->show();

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
        model->select();
        ui.tableView->setModel(model);
        ui.tableView->show();

To copy to clipboard, switch view to plain text mode