Antebios
29th January 2009, 20:07
I'm using 4.4.3, so I'm trying to create a proof-of-concept page and playing with display widgets. I have a table with 2 columns (ID, Description) and want to store the ID in a Data Value field and Description in a Text Value field, and ID field invisible and Description field visible. I know how to do this in .Net C#, but how do I do this in Qt?
This is what I've done:
QComboBox *cmbBox = Concept::ui.cmbItems;
QSqlQueryModel *_model = new QSqlQueryModel;
_model->setQuery("select lookupid, lookupdescr from tblLookup");
cmbBox->clear();
cmbBox->setModel(_model);
But, only the ID field is shown, so I used:
cmbBox->setModelColumn(1);
but either the primary key shows up, and the rest of the Description text, or only the first item and the second item is not visible.
I've been searching for help, but the documentation doesn't tell me how to do this. I want to get the ID from the selected item, but not show it.
This is what I've done:
QComboBox *cmbBox = Concept::ui.cmbItems;
QSqlQueryModel *_model = new QSqlQueryModel;
_model->setQuery("select lookupid, lookupdescr from tblLookup");
cmbBox->clear();
cmbBox->setModel(_model);
But, only the ID field is shown, so I used:
cmbBox->setModelColumn(1);
but either the primary key shows up, and the rest of the Description text, or only the first item and the second item is not visible.
I've been searching for help, but the documentation doesn't tell me how to do this. I want to get the ID from the selected item, but not show it.