[Qt-interest] QSqlRelation and order of items in combo box

[Jan]

Hi

you could use mMdl->relationModel([column])->setSort(...);


Jan

Am 23.04.2010 09:46, schrieb Harry Sfougaris:
> Hi all,
>
> When using an QSqlRelation, is there a way to specify the order of the items
> in the detail table?
> If I have
> QSqlRelationalTableModel   *mMdl = new QSqlRelationalTableModel(this);
> mMdl->setTable("masterTbl");
> mMdl->setRelation(master_fld1, QSqlRelation("detailTbl", "id", "descr"));
> and then
> ui->tblView->setItemDelegate(new QSqlRelationalDelegate(this));
>
> I get a combo box in ui->tblView (which is a QTableView) for the field
> master_fld1.
> However, I would like to change the sort order of the items, as it is
> currently undefined (there is no ORDER BY section in the SQL that is sent to
> the server for detailTbl).
> Can I either specify somehow an ORDER BY for QSqlRelation, or change the
> sort order of the items in the combo box?
>
> Thank  you,
> Harry
>
>
>
>
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest