Hi,

I'm trying to display model's data from sqlite db in QTableView.
I'm doing the follow but there is nothing inside the tableview.
PLEASE HELP!

Qt Code: 
  1. #include "clients.h"
  2. #include "ui_clients.h"
  3. #include <QSqlQueryModel>
  4. #include <QMessageBox>
  5. #include <QSqlQuery>
  6. #include <QSqlTableModel>
  7. #include <QSqlError>
  8. #include <QDebug>
  9.  
  10. Clients::Clients(QWidget *parent) :
  11.     QDialog(parent),
  12.     ui(new Ui::Clients)
  13. {
  14.     ui->setupUi(this);
  15.  
  16.     QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
  17.     db.setDatabaseName("faktura.sqlite");
  18.     db.open();
  19.  
  21.  
  22.         model->setQuery("SELECT ClientId, ClientName, ClientAddress FROM clients");
  23.         model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
  24.         model->setHeaderData(1, Qt::Horizontal, QObject::tr("company name"));
  25.         model->setHeaderData(2, Qt::Horizontal, QObject::tr("address"));
  26.  
  27.         ui->tableView_clients->setModel(model);
  28.         ui->tableView_clients->setColumnWidth(0,100);
  29.         ui->tableView_clients->setColumnWidth(1,100);
  30.         ui->tableView_clients->setColumnWidth(2,100);
  31.         ui->tableView_clients->horizontalHeader()->setResizeMode(QHeaderView::Interactive);
  32.         ui->tableView_clients->horizontalHeader()->setStretchLastSection(true);
  33.         ui->tableView_clients->show();
  34. }
  35.  
  36.  
  37. Clients::~Clients()
  38. {
  39.     delete ui;
  40. }
  41.  
  42.  
  43. void Clients::on_pushButton_add_pressed()
  44. {
  45.     GroupsAddDialog *dialog=new GroupsAddDialog(this);
  46.     dialog->show();
  47. }
To copy to clipboard, switch view to plain text mode