Inserting Record

[Nefastious]

Hi there guys!

I'm having a small problem here, whenever i try to insert a QSqlRecord into a QSqlTableModel, I know that a new row is inserted (QTableView shows that) but data simply isn't displayed in the view (the fields remain blank). Here is the code:

in mainw.cpp

//this makes the adddialog SLOT to instantiate an "Add" dialog
void mainwindow::adddialogslot() {
    adddialog *add = new adddialog;
    add->show();
    if (add->Accepted) {
        model->insertRecord(-1,add->record);
    }
}

//this makes the adddialog SLOT to instantiate an "Add" dialog
void mainwindow::adddialogslot() {
    adddialog *add = new adddialog;
    add->show();
    if (add->Accepted) {
        model->insertRecord(-1,add->record);
    }
}

To copy to clipboard, switch view to plain text mode 

in adddialog.cpp

void adddialog::allowinput() {
 
    if (lineEdit_name->text().isEmpty() || lineEdit_surname->text().isEmpty()
         || lineEdit_phone->text().isEmpty() || lineEdit_phone1->text().isEmpty()
         || lineEdit_phone2->text().isEmpty() || lineEdit_phone3->text().isEmpty()
         || lineEdit_address->text().isEmpty() || lineEdit_year->text().isEmpty()
         || lineEdit_insurance->text().isEmpty() || lineEdit_HS->text().isEmpty()
         || lineEdit_diseases->text().isEmpty() || lineEdit_treat->text().isEmpty()
         || lineEdit_comp->text().isEmpty() || comboBox_day->currentText().isEmpty()
         || comboBox_month->currentText().isEmpty() || !(radioButton_M->isChecked() || radioButton_F->isChecked()) ) {
         QMessageBox::information(this, tr("Add Patient"), tr("Please fill in all of the required fields"));
     }
     else {
        record.setValue("name", lineEdit_name->text());
        record.setValue("surname", lineEdit_surname->text());
        if (radioButton_M->isChecked()) {
            record.setValue("gender", "M");
        }
        else {
            record.setValue("gender", "F");
        }
        record.setValue("birth date", comboBox_day->currentText() + "/" + comboBox_month->currentText() +"/"+ lineEdit_year->text());
        record.setValue("address", lineEdit_address->text());
        record.setValue("phone number", lineEdit_phone->text() + lineEdit_phone1->text() + lineEdit_phone2->text() + lineEdit_phone3->text());
        record.setValue("insurance number", lineEdit_insurance->text());
        record.setValue("health system", lineEdit_HS->text());
        record.setValue("diseases", lineEdit_diseases->text());
        record.setValue("treatments", lineEdit_treat->text());
        record.setValue("complications", lineEdit_comp->text());
    }
 }

void adddialog::allowinput() {

    if (lineEdit_name->text().isEmpty() || lineEdit_surname->text().isEmpty()
         || lineEdit_phone->text().isEmpty() || lineEdit_phone1->text().isEmpty()
         || lineEdit_phone2->text().isEmpty() || lineEdit_phone3->text().isEmpty()
         || lineEdit_address->text().isEmpty() || lineEdit_year->text().isEmpty()
         || lineEdit_insurance->text().isEmpty() || lineEdit_HS->text().isEmpty()
         || lineEdit_diseases->text().isEmpty() || lineEdit_treat->text().isEmpty()
         || lineEdit_comp->text().isEmpty() || comboBox_day->currentText().isEmpty()
         || comboBox_month->currentText().isEmpty() || !(radioButton_M->isChecked() || radioButton_F->isChecked()) ) {
         QMessageBox::information(this, tr("Add Patient"), tr("Please fill in all of the required fields"));
     }
     else {
        record.setValue("name", lineEdit_name->text());
        record.setValue("surname", lineEdit_surname->text());
        if (radioButton_M->isChecked()) {
            record.setValue("gender", "M");
        }
        else {
            record.setValue("gender", "F");
        }
        record.setValue("birth date", comboBox_day->currentText() + "/" + comboBox_month->currentText() +"/"+ lineEdit_year->text());
        record.setValue("address", lineEdit_address->text());
        record.setValue("phone number", lineEdit_phone->text() + lineEdit_phone1->text() + lineEdit_phone2->text() + lineEdit_phone3->text());
        record.setValue("insurance number", lineEdit_insurance->text());
        record.setValue("health system", lineEdit_HS->text());
        record.setValue("diseases", lineEdit_diseases->text());
        record.setValue("treatments", lineEdit_treat->text());
        record.setValue("complications", lineEdit_comp->text());
    }
 }

To copy to clipboard, switch view to plain text mode 

What am I doing wrong? Any code samples would be greatly appreciated.

Thanks in advance,

Nefastious

[Lykurg]

Are you sure, your record is valid? A field name with a white space like "insurance number" seems odd to me and maybe you need to set the integer index and not only the name? "Debug" a record which was created by the model and check it with the one you create.

[Nefastious]

Well using the following:

if (record.isEmpty()) {
            qDebug() << "It is empty";
        }

if (record.isEmpty()) {
            qDebug() << "It is empty";
        }

To copy to clipboard, switch view to plain text mode 

I am informed that the record is indeed empty.
What exactly am I doing wrong? Instead of name should I have specified the index instead?

Thanks in advance

[ChrisW67]

//this makes the adddialog SLOT to instantiate an "Add" dialog
void mainwindow::adddialogslot() {
    adddialog *add = new adddialog;
    add->show();
    if (add->Accepted) {
        model->insertRecord(-1,add->record);
    }
}

//this makes the adddialog SLOT to instantiate an "Add" dialog
void mainwindow::adddialogslot() {
    adddialog *add = new adddialog;
    add->show();
    if (add->Accepted) {
        model->insertRecord(-1,add->record);
    }
}

To copy to clipboard, switch view to plain text mode 

Line 4 opens a modeless dialog and immediately returns control. The user doesn't a have chance to do anything in the dialog before you grab the (empty) record and insert it. You probably wanted:

add->exec();

add->exec();

To copy to clipboard, switch view to plain text mode 

to open a modal dialog to wait for user data entry and confirmation.