innobleday
12th March 2010, 10:00
Hi All,
I've a problem when I aim to view data into QTableView. I aim to create an One-to-Many (OTM) Relationship in QtSqlRelation. the code can I do is one-to-one like this, I've no Idea for the OTM. How should it be ?.
model->setTable("Users");
model->setSort(User_Id, Qt::AscendingOrder);
model->setHeaderData(User_Name,Qt::Horizontal,tr("Username"));
model->setHeaderData(User_FirstName, Qt::Horizontal, tr("First name"));
model->setHeaderData(User_LastName, Qt::Horizontal, tr("Last Name"));
model->setRelation(User_Mode,QSqlRelation("UserModes","ID","Name"));
model->setHeaderData(User_Mode, Qt::Horizontal, tr("Type"));
model->select();
Thanks
Hary
I've a problem when I aim to view data into QTableView. I aim to create an One-to-Many (OTM) Relationship in QtSqlRelation. the code can I do is one-to-one like this, I've no Idea for the OTM. How should it be ?.
model->setTable("Users");
model->setSort(User_Id, Qt::AscendingOrder);
model->setHeaderData(User_Name,Qt::Horizontal,tr("Username"));
model->setHeaderData(User_FirstName, Qt::Horizontal, tr("First name"));
model->setHeaderData(User_LastName, Qt::Horizontal, tr("Last Name"));
model->setRelation(User_Mode,QSqlRelation("UserModes","ID","Name"));
model->setHeaderData(User_Mode, Qt::Horizontal, tr("Type"));
model->select();
Thanks
Hary