CODEWITHSUNDEEP
c++sqlqtsqlite
stackOverflow
stackOverflow

Reputation: 179

Qt Sql INSERT statement has no effect

I am using Qt 4.8 on Windows. In the simple program INSERT statement does not seem to be working. Basic debugging statements doesn't show any error string. Google could not help me. on SO similar question exists.

sql.h

#ifndef SQL_H
#define SQL_H
#include<QtSql>
#include<QtGui>
#include<QDebug>
class Unit
{
public:
    Unit()
    {
        QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
        db.setDatabaseName("x");
        bool ok = db.open();

        QSqlQuery query;
        query.exec("create table vidyarthi(section integer(10), unit integer(10), details varchar(500));");


        query.exec("insert into vidyarthi values( 1,2,'Hello world');");

        qDebug()<<query.lastError().databaseText(); // prints "" means empty
        qDebug()<<query.lastError().text(); // prints  "" means empty


        QSqlTableModel *tmodel=new QSqlTableModel;
        tmodel->setTable("vidyarthi");
        qDebug()<<tmodel->rowCount(); // prints 0


        QTableView *tv=new QTableView;
        tv->setModel(tmodel);
        tv->show();
    }

};

#endif // SQL_H

The main() function:-

#include "widget.h"
#include <QApplication>
#include<QtCore>
#include<sql.h>
int main(int argc, char *argv[])
{
   QApplication a(argc, argv);

    Unit unit;

   return a.exec();
}

My output TableView has only just headers actually (columns of the table) but no rows.

Upvotes: 0

Views: 768

Answers (1)

Leiaz
Leiaz

Reputation: 2917

You have to call QSqlTableModel::select() to populate the model with data.

This is explained in the detailled description of the QSqlTableModel class.

Upvotes: 3

Related Questions