QTableView & QSqlRelationalTableModel

[jippo]

I have the following code. Only first of those relations have default value in combobox in the tableview in lisaa function. Only difference between those relations is, "prosentti" is integer, and "rooli" is text. I'm using SQLITE backend.

I need to have a default value also in the second, "rooli", relation. But no go.

Constructor:

model = new QSqlRelationalTableModel();
	model->setTable("tili");
	model->setRelation(3, QSqlRelation("alv", "id", "prosentti"));
	model->setRelation(4, QSqlRelation("vast", "id", "rooli"));
	model->select();
 
	tiliView->setModel(model);
	tiliView->setItemDelegate(new QSqlRelationalDelegate(tiliView));

model = new QSqlRelationalTableModel();
	model->setTable("tili");
	model->setRelation(3, QSqlRelation("alv", "id", "prosentti"));
	model->setRelation(4, QSqlRelation("vast", "id", "rooli"));
	model->select();
	
	tiliView->setModel(model);
	tiliView->setItemDelegate(new QSqlRelationalDelegate(tiliView));

To copy to clipboard, switch view to plain text mode 

Lisaa:

void TiliWindow::lisaa()
{
    int r = model->rowCount();
    model->insertRows(r, 1);
    QModelIndex index = model->index(r,1);
    tiliView->setCurrentIndex(index);
 
    tiliView->edit(index);

void TiliWindow::lisaa()
{
    int r = model->rowCount();
    model->insertRows(r, 1);
    QModelIndex index = model->index(r,1);
    tiliView->setCurrentIndex(index);
    
    tiliView->edit(index);

To copy to clipboard, switch view to plain text mode