Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. [SOLVED] QCombobox + QSqlQueryModel
Forum Updated to NodeBB v4.3 + New Features

[SOLVED] QCombobox + QSqlQueryModel

Scheduled Pinned Locked Moved General and Desktop
3 Posts 2 Posters 4.9k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Offline
    L Offline
    lfdm
    wrote on last edited by
    #1

    Hi guys,

    I'm making a simple database application and want to do filtering on combo boxes.

    I have a products table and a modules table having a foreign key field pointing to products id column; finally I have a features table having a foreign key field pointing to modules id column; nothing fancy:
    @
    +------------------------+
    | Products |
    +------------------------+
    |id | name | description |
    +------------------------+

    +-------------------------------------+
    | Modules |
    +-------------------------------------+
    |id | productsid | name | description |
    +-------------------------------------+

    +-------------------------------------+
    | Features |
    +-------------------------------------+
    |id | modulessid | name | description |
    +-------------------------------------+@

    Then I have a form for entering the features. This form has 2 combo boxes, one for products and one for modules and I want to show only the modules that belong to a product.

    For this I have database manager class returning QSqlQueryModel pointer for both products and modules:

    @QSqlQueryModel* CDatabaseManager::productsQueryModel()
    {
    if (m_pProductsQueryModel == NULL)
    {
    m_pProductsQueryModel = new QSqlQueryModel(this);
    }

    m_pProductsQueryModel->setQuery("SELECT * FROM products");

    return m_pProductsQueryModel;
    }

    QSqlQueryModel* CDatabaseManager::modulesQueryModel()
    {
    if (m_pModulesQueryModel == NULL)
    {
    m_pModulesQueryModel = new QSqlQueryModel(this);
    }

    m_pModulesQueryModel->setQuery("SELECT * FROM modules");

    return m_pModulesQueryModel;
    }@

    I set both those pointers to the QComboBox objects and everything displays nicely except that I only want to see the modules assigned to a product.

    On the products combox box, I have a slot called when the current index of Products combo box is triggered. I get the selected product ID from the resultset and trigger a signal for the database manager to update the modules query and select only the items having the correct product ID in the second column.

    Simpler, in code that gives:

    @void AddFeatureDialog::on_productsCombobox_currentIndexChanged(int index)
    {
    QModelIndex id = ui->productsCombobox->model()->index(index, 0);
    m_nProductId = id.data().toInt();
    emit currentProductSelChanged(m_nProductId);
    }

    void CDatabaseManager::onCurrentProductSelChanged( int _nProductId )
    {
    bool bRet = false;
    if (m_db.isOpen())
    {
    QSqlQuery query;
    bRet = query.prepare("SELECT * FROM modules WHERE productid=:productid");
    query.bindValue(":productid", _nProductId);
    m_pModulesQueryModel->setQuery(query);

        if (bRet)
        {
            // How do I update the model
        }
        else
        {
            QSqlError err = query.lastError();
            //... 
        }
    }
    

    }@

    The form is simply a modal dialog:
    @void MainWindow::on_action_Feature_triggered()
    {
    AddFeatureDialog dlg;
    dlg.setProductsModel((QAbstractItemModel*)m_pDatabase->productsQueryModel());
    dlg.setModulesModel((QAbstractItemModel*)m_pDatabase->modulesQueryModel());

    connect(&dlg, SIGNAL(currentProductSelChanged(int)), m_pDatabase, SLOT(onCurrentProductSelChanged(int)));
    
    if (dlg.exec() == QDialog::Accepted)
    {}
    

    }@

    The problem here is that according to the documentation doing a setQuery() on the model should be enough to update the view. In my case the combox box gets cleared and remains empty. If within the slot I set a original query, the combo box gets empty; if I set the filter query from the form class (which I wouldn't like to do), the combo gets empty too.

    What am I doing wrong?

    Cheers,

    Damien LEFEVRE - http://www.lfdm.net

    1 Reply Last reply
    0
    • T Offline
      T Offline
      tim.sullivan
      wrote on last edited by
      #2

      Could you also post the section where you populate the combobox?

      1 Reply Last reply
      0
      • L Offline
        L Offline
        lfdm
        wrote on last edited by
        #3

        Well that was easy thanks to my colleague =)

        In the slot taking care of filtering

        @QSqlQuery query;
        bRet = query.prepare("SELECT * FROM modules WHERE productid=:productid");
        query.bindValue(":productid", _nProductId);
        m_pModulesQueryModel->setQuery(query);@

        becomes:
        @QSqlQuery query;
        bRet = query.prepare("SELECT * FROM modules WHERE productid=:productid");
        query.bindValue(":productid", _nProductId);
        query.exec(); // <--------- Add exec or it won't work
        m_pModulesQueryModel->setQuery(query);@

        So what the documentation does not stipulate is that exec must be called prior to setting the query.

        Tim, the combox box is automatically populated by the model / view architecture. Practically the only things required are to set a valid query to a QXmlQueryModel object and set that same QXmlQueryModel object to the QComboBox object using setModel.

        Cheers,

        Damien LEFEVRE - http://www.lfdm.net

        1 Reply Last reply
        0

        • Login

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • Users
        • Groups
        • Search
        • Get Qt Extensions
        • Unsolved