Set model not working!!

[aurora]

I am using QSqlQuerModel in my program and using table view to display the contents of the model.
But when i set the model nothing displays in the table other than two brown lines at the horizontal and verticla headers.....
my program code....

void win::on_pushButton_clicked()
{
 
    QStringList signalList;
    QString filename;
    filename="C:/Users/Desktop/abc.txt";
    headersList=GetheaderNames(filename);
 
    QFileInfo file(filename);
    createTable(file.baseName(),headersList);
    GetFileContent(filename);
   QSqlQueryModel plainModel2;
        initializeModel(&plainModel2,file.baseName(),headersList);
 
 ui->tableView_2->setModel(&plainModel2);
}

void win::on_pushButton_clicked()
{

    QStringList signalList;
    QString filename;
    filename="C:/Users/Desktop/abc.txt";
    headersList=GetheaderNames(filename);
 
    QFileInfo file(filename);
    createTable(file.baseName(),headersList);
    GetFileContent(filename);
   QSqlQueryModel plainModel2;
        initializeModel(&plainModel2,file.baseName(),headersList);
     
 ui->tableView_2->setModel(&plainModel2);
}

To copy to clipboard, switch view to plain text mode 

initialiseModel function

void initializeModel(QSqlQueryModel *model,QString filename, QStringList headersList)
{
    QString queryString=QString("select * from %1").arg(filename);
 
model->setQuery(queryString);
    for(int i=0;i<headersList.count();i++)
    {
       model->setHeaderData(i, Qt::Horizontal, (headersList.at(i)));
    }
 
}

void initializeModel(QSqlQueryModel *model,QString filename, QStringList headersList)
{
    QString queryString=QString("select * from %1").arg(filename);

model->setQuery(queryString);
    for(int i=0;i<headersList.count();i++)
    {
       model->setHeaderData(i, Qt::Horizontal, (headersList.at(i)));
    }

}

To copy to clipboard, switch view to plain text mode 

plz help me to sort out the problm here!!

[Jonny174]

Is it work?

model->setHeaderData(i, Qt::Horizontal, (headersList.at(i)));

model->setHeaderData(i, Qt::Horizontal, (headersList.at(i)));

To copy to clipboard, switch view to plain text mode 

Output headersList.at(i) with qDebug();
Try create plainModel2 in heap.

QSqlQueryModel *plainModel2 = new QSqlQueryModel;
initializeModel( plainModel2, file.baseName(), headersList );

QSqlQueryModel *plainModel2 = new QSqlQueryModel;
initializeModel( plainModel2, file.baseName(), headersList );

To copy to clipboard, switch view to plain text mode 

---

Added after 5 minutes:

Check errors

model->setQuery(queryString);
if (model->lastError().isValid())
     qDebug() << model->lastError().text();

model->setQuery(queryString);
if (model->lastError().isValid())
     qDebug() << model->lastError().text();

To copy to clipboard, switch view to plain text mode 

[aurora]

Thank u jonny......as u identified, i created it on stack......now its working....

[Santosh Reddy]

You are creating the model on stack, which will not work in your case, as it will go out of scope after on_pushButton_clicked(0 is exited.

Create the model on heap.

QSqlQueryModel* plainModel2 = new QSqlQueryModel(...)