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

[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@xxxxxxxxxxxxx
http://lists.trolltech.com/mailman/listinfo/qt-interest