QSqlTableModel

[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