What i want is to load .sqlite file and dimply query in table.
Unfortunately no table is displayed, just empty window.
Database file is in the project main folder.


Qt Code:
  1. QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
  2.  
  3. //db.setDatabaseName(QApplication::applicationDirPath() + QDir::separator() + "faktura.sqlite");
  4. db.setDatabaseName("faktura.sqlite");
  5. db.open();
  6.  
  7.  
  8.  
  9. model->setQuery("SELECT customer_id,name, address FROM customers");
  10. model->setHeaderData(0, Qt::Horizontal, QObject::tr("Field 1"));
  11. model->setHeaderData(1, Qt::Horizontal, QObject::tr("Field 2"));
  12. model->setHeaderData(2, Qt::Horizontal, QObject::tr("Field 3"));
  13.  
  14.  
  15.  
  16. QTableView *view = new QTableView;
  17. view->setModel(model);
  18. view->show();
To copy to clipboard, switch view to plain text mode