join is not working

hi could anyone help me? I want join two tables into one, this code is working on my friends qt+db2 but on my qt+ingres isn't.

Code:

---

void FouDialog::on_pushButton_4_clicked()
{
    int num_rows, r, c;
    QSqlQuery q(db);
 
    if(!q.exec("SELECT count(id_wizyty) as num_rows FROM wizyta")) qDebug() << q.lastError().text();
    q.first();
    num_rows = q.value(0).toInt();
 
    ui->tableWidget->setRowCount(num_rows);
 
    //if(!q.exec("SELECT * FROM wizyta ")) qDebug() << q.lastError().text();
    if(!q.exec("SELECT id_wizyty, data, w.id_pacjenta, id_lekarza, p.imie as Imie_Pacjenta ,p.nazwisko as Nazwisko_Pacjenta FROM wizyta w JOIN pacjent p ON w.id_pacjenta = p.id_pacjenta")) qDebug() << q.lastError().text();
    for(r = 0, q.first(); q.isValid(); q.next(), ++r){
        for(c = 0; c < 6; ++c){
            ui->tableWidget->setItem(r,c, new QTableWidgetItem(q.value(c).toString()));
        }
    }
}

---

What do you mean "is not working" ?

columns from pacjent tables are not added into wizyta table

Quote:

---

columns from pacjent tables are not added into wizyta table

---

Nothing in your code tries to add columns (or rows) to any database table.


Does the query exec() call return true? Does your lastError() report anything?

Does

Code:

---

SELECT id_wizyty, data, w.id_pacjenta, id_lekarza, p.imie as Imie_Pacjenta ,p.nazwisko as Nazwisko_Pacjenta 
FROM wizyta w 
  JOIN pacjent p ON w.id_pacjenta = p.id_pacjenta

---

Execute in isql and return what you expect?

Does the execution enter your for loop? Is there a reason you did not use the more idiomatic:

Code:

---

while (q.next()) {
  // do stuff
}

---

Quote:

---

Originally Posted by ChrisW67

Nothing in your code tries to add columns (or rows) to any database table.


Does the query exec() call return true? Does your lastError() report anything?

Does

Code:

---

SELECT id_wizyty, data, w.id_pacjenta, id_lekarza, p.imie as Imie_Pacjenta ,p.nazwisko as Nazwisko_Pacjenta 
FROM wizyta w 
  JOIN pacjent p ON w.id_pacjenta = p.id_pacjenta

---

Execute in isql and return what you expect?

---

0 errors, in visual SQL it returns what it should

Has your program successfully open()ed the database?
Does the code you have shown us actually get executed?
Does the query returning the count() work?

Database if opened successfully, I can add, edit, remove and see all records from my database in qt app, I just can't use join to see records from two tables in one.

ok I fixed it with ui->tableWidget->setColumnCount(6); and now it is working as it should, thanks for all your help, regards!