Update combobox data from model

rudag

I have a categories QComboBox which is linked to a QSqlTableModel. Also I have a second window to manage categories (add/remove). How to update/refresh/reload the combobox whenever a category is added/removed?

My code:

int catIndex = model2->fieldIndex("category");
model2->setRelation(catIndex, QSqlRelation("categories", "id", "name"));
QSqlTableModel *catModel = model2->relationModel(catIndex);
ui->comboBox_2->setModel(catModel);
ui->comboBox_2->setModelColumn(catModel->fieldIndex("name"));
mapper->addMapping(ui->comboBox_2, catIndex);

m.sue

Hi @rudag

after adding/removing in your second window send a signal to a slot of the object where you call "your code" and in the slot call "your code" again.

-Michael.

SGaist

Hi,

How are you adding / removing these categories ?

rudag

@m-sue
I can call the main window from the categories window. Problem is I don't know the code to reload the QComboBox.

@SGaist
It's another window which has a QTableView with a QSqlTableModel linked to the categories table.

m.sue

Hi @rudag

I do not understand. You wrote the code in your first post. Just call it again. Then the changed model should refill the combobox.

If you want the model to update your combobox, though, you will probably have to derive your own model class and override the functions for update and remove of data sets.

-Michael.

rudag

@m-sue
I'm getting the following error when I try to call that piece of code more than once:
QComboBox::setModel: cannot set a 0 model

SGaist

Then why not share the model between the widgets ?

rudag

I did this:

ui->comboBox->clear();
((QSqlTableModel*)ui->comboBox->model())->select();

And it's working!