reset value of combobox based on stored data in db

[waynew]

I don't know about mapper, but here is how I initialize my combo boxes with db values:

// Retrieves the preferences to populate the dialog when it opens
void PreferencesDialog::getPreferences(QString ctrlConn)
{
   QSqlDatabase db = QSqlDatabase::database(ctrlConn);
   db.open();
   QSqlRecord record;
   QSqlTableModel* model = new QSqlTableModel(this, db);
   model->setTable("preferences");
   model->select();
   record = model->record(0);
 
m_ui->cbPort->setCurrentIndex(m_ui->cbPort->findText(record.value("port").toString()));

// Retrieves the preferences to populate the dialog when it opens
void PreferencesDialog::getPreferences(QString ctrlConn)
{
   QSqlDatabase db = QSqlDatabase::database(ctrlConn);
   db.open();
   QSqlRecord record;
   QSqlTableModel* model = new QSqlTableModel(this, db);
   model->setTable("preferences");
   model->select();
   record = model->record(0);

m_ui->cbPort->setCurrentIndex(m_ui->cbPort->findText(record.value("port").toString()));

To copy to clipboard, switch view to plain text mode 

Does that help any?

[Urthas]

For the sake of completeness, it is worth mentioning QSettings as well. That approach may or may not be appropriate depending on the scope and intended usage of your application. That is to say: are your users on their own machines or on public workstations? If the former, a database *may* be overkill for remembering some settings, and you can offload work from your server via QSettings.

[rdjenner]

I'm still confused. The drop down options are static. On an existing record, the value in my db record will have either B or S. So on entry of a new record, BUSHING or STRUCTURAL are the only options. When the user makes a selection from the drop down, the correct B or S is stored. What I need to happen is when the record is recalled, for the dropdown to display the proper value, either BUSHING or STRUCTURAL based on the B or S value from the db record in the drop down

[waynew]

How are you recalling the db data? What does the code look like?