QSqlTableModel

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();

Code:

---

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();

---

If somebody have some finish examples why not :p

Thanks again :rolleyes:

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 ;)

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:

Code:

---

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();

---

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:

Code:

---

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

---

I would like to use :

Code:

---

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

---

Can somebody show me how to use it?

Code:

---

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

---

But it's better to do it this way:

Code:

---

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

---

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

Code:

---

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);

---

For Update a Value it works now like this:

Code:

---

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();

---