[solved] QSqlTableModel not showing in QTableView

matobodo

class Sql
sql.h
@
public:
QSqlTableModel* getCiselnikydata(QString type);
@

sql.cpp
@
QSqlTableModel* Sql::getCiselnikydata(QString type)
{
QSqlTableModel *ciselnikyDataModel = new QSqlTableModel(this,db);
ciselnikyDataModel->setTable("ciselniky");
ciselnikyDataModel->select();
qDebug() << ciselnikyDataModel->lastError().text();
return ciselnikyDataModel;
}
@

class CiselnikyOkno
ciselnikyokno.h
@
private:
QSqlTableModel *data;

private slots:
void showData(int row);
@

ciselnikyokno.cpp
@
void CiselnikyOkno::showData(int row)
{
if (row >= 0) {
Sql sql;
if (sql.connect()) {
data = sql.getCiselnikydata(ui->type->currentText());
ui->table->setModel(data);
}
}
}
@

The problem is that nothing shows in my QTableView (ui->table)

SGaist

Hi,

Maybe a silly question but, are you sure there's something in the table ?

matobodo

Hi,

i have data in the table and no error shows
qDebug() << ciselnikyDataModel->lastError().text();

SGaist

Ok, then also check the row/column count of your model to ensure there's something in it

matobodo

i have added this code
@
qDebug() << ciselnikyDataModel->rowCount();
qDebug() << ciselnikyDataModel->columnCount();
@

after the line
@
qDebug() << ciselnikyDataModel->lastError().text();
@

in sql.cpp. it returns me that i have 10 rows and 4 columns, the same as in the database

SGaist

Found it:

@QSqlTableModel *ciselnikyDataModel = new QSqlTableModel(this,db);@

You are giving your model a parent here however, your Sql object gets destroyed before the end of showData which in turns deletes the model and thus you won't have anything to show.

matobodo

So the solution is to add this line into ciselnikyokno.h
@
Sql *sql;
@

and this line into ciselniky.cpp
@
sql = new Sql(this);
@

It works for me, but I have one question.
Have I done it correct?

SGaist

You can simply not set the model parent when constructing it