QTableView and QSQLTableModel

[raphaelf]

Its not easy to bring this on text

I try again:

I am testing QSqlTableView class for update, delete and insert a new dataset (record) in a Table.

My situation now:
i am able to update a Table like this (really easy, i had just to change the EditStrategy ):

QString table = ui.tabelle_le->text();
		QSqlTableModel *model = new QSqlTableModel;
        model->setTable(table);
        //So kann man jeder Feld update: OnFiledChange
        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);
        //So kann man jeder Feld update: OnFiledChange
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
        model->select();
        ui.tableView->setModel(model);
        ui.tableView->show();

To copy to clipboard, switch view to plain text mode 

i am able too, to delete a dataset like this(very simple):

.
.
model->removeRows(x,1);

.
.
model->removeRows(x,1);

To copy to clipboard, switch view to plain text mode 

What i need now, is to find a simple way, how to insert a new dataset over my tableView
I now that i can use this:

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

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

To copy to clipboard, switch view to plain text mode 

So my problem is:
1. I have 18 tables
2. every table has between 2 and 23 columns.
3. How to insert a new dataset over my TableView in a easy Way independent of which table is set as Modal?

I hope i could explain better, if not i shoul lern more english

[wysota]

Just insert an empty row into your model using insertRow() or insertRecord() with an empty record and order the view to go into edit mode on the newly inserted row.

[raphaelf]

Hi Wysota!
finally i am able now to input a new rec
I hope you mean like that:

void MainWindow::insertNewRow()
{	
	QString table = ui.tabellen_cb->currentText();
	QSqlTableModel *model = new QSqlTableModel;
    model->setTable(table);
    model->setEditStrategy(QSqlTableModel::OnFieldChange);
    model->select();
 
    ui.tableView->setModel(model);
    ui.tableView->show();
 
    //Just insert an empty row into your model using insertRow() or insertRecord() 
	//with an empty record 
    QSqlRecord rec = model->record();
    model->insertRecord(-1, rec);
 
    //and order the view to go into edit mode on the newly inserted row.
    model->setEditStrategy(QSqlTableModel::OnRowChange); 
}

void MainWindow::insertNewRow()
{	
	QString table = ui.tabellen_cb->currentText();
	QSqlTableModel *model = new QSqlTableModel;
    model->setTable(table);
    model->setEditStrategy(QSqlTableModel::OnFieldChange);
    model->select();
    
    ui.tableView->setModel(model);
    ui.tableView->show();
	
    //Just insert an empty row into your model using insertRow() or insertRecord() 
	//with an empty record 
    QSqlRecord rec = model->record();
    model->insertRecord(-1, rec);
    
    //and order the view to go into edit mode on the newly inserted row.
    model->setEditStrategy(QSqlTableModel::OnRowChange); 
}

To copy to clipboard, switch view to plain text mode