Automatically refresh QSqlQueryModel from external from dialog

[windsword]

Hello,

I want to automatically refresh my table, after I add a new record to the database.

I use a button to bring up a dialog form, in the "accept" button slot I'd like to refresh it before
executing the "accept()" function. But I get an error message that the

model

is not defined in this class.

void AddClientForm::addclient2db_accept()
{ // this is the slot called to accept the entry and INSERT it into the desired table
    .... code adding data to db record ...
    model->clear();
    model->setQuery("SELECT FirstName,LastName,ClientID FROM Clients");
    model->setHeaderData(0,Qt::Horizontal, tr("First"));
    model->setHeaderData(1,Qt::Horizontal, tr("Last Name"));
    model->setHeaderData(2,Qt::Horizontal, tr("Client ID"));
 
    accept();
}

void AddClientForm::addclient2db_accept()
{ // this is the slot called to accept the entry and INSERT it into the desired table
    .... code adding data to db record ...
    model->clear();
    model->setQuery("SELECT FirstName,LastName,ClientID FROM Clients");
    model->setHeaderData(0,Qt::Horizontal, tr("First"));
    model->setHeaderData(1,Qt::Horizontal, tr("Last Name"));
    model->setHeaderData(2,Qt::Horizontal, tr("Client ID"));

    accept();
}

To copy to clipboard, switch view to plain text mode 

model is defined in another class, but the above slot is define as shown in this header file:

/* AddClientForm - Add a new client to the database */
class AddClientForm : public QDialog
{
    Q_OBJECT
 
public:
    AddClientForm(QWidget *parent=0);
 
private slots:
    void addclientform_reset();
    void addclient2db_accept();

/* AddClientForm - Add a new client to the database */
class AddClientForm : public QDialog
{
    Q_OBJECT

public:
    AddClientForm(QWidget *parent=0);

private slots:
    void addclientform_reset();
    void addclient2db_accept();

To copy to clipboard, switch view to plain text mode 

Do I need to inherit the parent class (where the button to add a new record is defined)?


Reference:
http://www.qtcentre.org/forum/f-qt-p...del-21742.html

[victor.fernandez]

Just pass the form a pointer to the model. You may do it in the constructor:

class AddClientForm : public QDialog
{
    Q_OBJECT
 
public:
    AddClientForm(QSqlQueryModel *model, QWidget *parent=0);
 
private slots:
    void addclientform_reset();
    void addclient2db_accept();
 
private:
    QSqlQueryModel *m_model;

class AddClientForm : public QDialog
{
    Q_OBJECT
 
public:
    AddClientForm(QSqlQueryModel *model, QWidget *parent=0);
 
private slots:
    void addclientform_reset();
    void addclient2db_accept();

private:
    QSqlQueryModel *m_model;

To copy to clipboard, switch view to plain text mode 

AddClientForm::AddClientForm(model, parent)
 : QDialog(parent) {
    m_model = model;
    ...
}
 
void AddClientForm::addclient2db_accept()
{ // this is the slot called to accept the entry and INSERT it into the desired table
    .... code adding data to db record ...
    m_model->clear();
    m_model->setQuery("SELECT FirstName,LastName,ClientID FROM Clients");
    m_model->setHeaderData(0,Qt::Horizontal, tr("First"));
    m_model->setHeaderData(1,Qt::Horizontal, tr("Last Name"));
    m_model->setHeaderData(2,Qt::Horizontal, tr("Client ID"));
 
    accept();
}

AddClientForm::AddClientForm(model, parent)
 : QDialog(parent) {
    m_model = model;
    ...
}

void AddClientForm::addclient2db_accept()
{ // this is the slot called to accept the entry and INSERT it into the desired table
    .... code adding data to db record ...
    m_model->clear();
    m_model->setQuery("SELECT FirstName,LastName,ClientID FROM Clients");
    m_model->setHeaderData(0,Qt::Horizontal, tr("First"));
    m_model->setHeaderData(1,Qt::Horizontal, tr("Last Name"));
    m_model->setHeaderData(2,Qt::Horizontal, tr("Client ID"));
 
    accept();
}

To copy to clipboard, switch view to plain text mode 

AddClientForm *form = new AddClientForm(model, this);
form->show();

AddClientForm *form = new AddClientForm(model, this);
form->show();

To copy to clipboard, switch view to plain text mode