PDA

View Full Version : How to filter QSqlRelationalTable?



istdasklar
28th March 2007, 16:48
When I do this :

model = new QSqlRelationalTableModel;
model->setTable("table");
tableView->setModel(model);
model->setFilter ("id = 660");
IT's Works!


But when I do this :

model = new QSqlRelationalTableModel;
model->setTable("personne");
model->setRelation(3, QSqlRelation("status", "id", "nom"));
tableView->setItemDelegate(new QSqlRelationalDelegate(tableView));
tableView->setModel(model);
model->setFilter ("id = 660");
It's doesn't work !! Why ?

tranfuga25s
30th March 2007, 17:10
Because you have to use the relationated filed name to filter...


model = new QSqlRelationalTableModel;
model->setTable("personne");
model->setRelation(3, QSqlRelation("status", "id", "nom"));
tableView->setItemDelegate(new QSqlRelationalDelegate(tableView));
tableView->setModel(model);
model->setFilter ("mon = *****");
Don`t now why, but seems to work that way...