QTableView doesn't paint correctly

Dear visitor, welcome to QtForum.org. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

chang112x

Beginner

Posts: 15

Occupation: Programmer and all sort of thing to survive.

Wednesday, June 8th 2011, 2:03am

QTableView doesn't paint correctly

Hi, i'm programming a simple sqlite manager in qt.
All is working, just the fact that the QTableView i use, doesn't paint correctly where i positioned it in the designer, instead, it obscure all the menu, and i can't access it, and this is not good, obviously.
Data is loaded correctly when i open the database file.
I attach i file to let you see what is the situation.

How i can fix it ?

I also post the source code:

The Constructor

Source code

FiereMainWindow::FiereMainWindow(QWidget *parent) :     QMainWindow(parent),
     ui(new Ui::FiereMainWindow),
     defaultDatabaseName("fiere.db") {
      ui->setupUi(this);
      sqliteDatabase = QSqlDatabase::addDatabase("QSQLITE");
      sqlTableModel = new QSqlTableModel(this, sqliteDatabase);
     sqlTableModel->setEditStrategy(QSqlTableModel::OnFieldChange);
      databaseTableView = new QTableView(this);
     databaseTableView->setModel(sqlTableModel);
     databaseTableView->setFixedHeight(500);
     databaseTableView->setFixedWidth(500);
      if(!openSqliteDatabase((QString&)defaultDatabaseName)) {
        statusBar()->showMessage(tr("File Database non aperto, errore."));
      }
  }

The open function

Source code

bool FiereMainWindow::openSqliteDatabase(QString& path) {      const char* databaseTableUtenteFields[] = {
          "id"       ,
         "nome"     ,
         "cognome"  ,
         "nazione"  ,
         "fiera_id" ,
         "anno"     ,
         "indirizzo",
         "citta"    ,
         "code"     ,
         "email"    ,
         "importo"
      };
     QString prova;
     QString fileNotFound_ErrorMessage = tr("Impossibile aprire il file ") + path + tr(": il file non esiste o c'è stato qualche altro problema. Verificare la presenza del file nel sistema, il path, la cartella, la configurazione e quanto può essere possibile per risolvere il problema");
     if(!QFile::exists(path)) {
        QMessageBox::warning(this, tr("Warning"), fileNotFound_ErrorMessage, QMessageBox::Ok);
       return false;
     }
      sqliteDatabase.setDatabaseName(path);
     if(!sqliteDatabase.open()) {
         QMessageBox::warning(this, tr("Warning"), tr("Errore durante l'apertura del database") + sqliteDatabase.lastError().databaseText(), QMessageBox::Ok);
        return false;
     }
     sqlTableModel->setTable("UTENTE");
     for(unsigned int i = 0; i < sizeof(databaseTableUtenteFields) / sizeof(databaseTableUtenteFields[0]); i++) {
        sqlTableModel->setHeaderData(i, Qt::Horizontal, tr(databaseTableUtenteFields[i]));
        prova += databaseTableUtenteFields[i];
       prova += "\n";
     }
     qDebug(qPrintable(prova));
     sqlTableModel->select();
    sqlTableModel->submitAll();
     statusBar()->showMessage(tr("File Database aperto, all is good."));
     return true;
  }

And that's it.
If you need something else, just ask.
I'm running QtCreator 2.1.0, with Qt 4.7.1, on Windows 7 Home Premium machine.

Thank you in advance,
Marco.

chang112x has attached the following files:

gestionale-error.PNG (60.13 kB - 13 times downloaded - latest: Apr 1st 2012, 7:45am)
gestionale-error-2.PNG (69.05 kB - 13 times downloaded - latest: Apr 1st 2012, 7:46am)

Go to the top of the page

pele1410

Trainee

Posts: 118

Location: Lafayette, LA

Wednesday, June 8th 2011, 1:04pm

If you've created databaseTableView in your UI file, then you don't need to create another one in the class files. Just reference the UI::databaseTableView. You're basically creating 2 instances of the tableView right now. This should work:

.h

Source code

#include <QMainWindow>
#include "ui_FiereMainWindow.h"

class FiereMainWindow: public QMainWindow, private Ui::FiereMainWindow
{
   Q_OBJECT

public:
   FiereMainWindow(QWidget *parent = 0);

private:
   Ui::FiereMainWindow ui;
};

//.cpp

Source code

FiereMainWindow::FiereMainWindow(QWidget *parent) : QMainWindow(parent),
     defaultDatabaseName("fiere.db") 
{
   ui.setupUi(this);

   sqliteDatabase = QSqlDatabase::addDatabase("QSQLITE");
   sqlTableModel = new QSqlTableModel(this, sqliteDatabase);
   sqlTableModel->setEditStrategy(QSqlTableModel::OnFieldChange);
     
   ui.databaseTableView->setModel(sqlTableModel);
   ui.databaseTableView->setFixedHeight(500);
   ui.databaseTableView->setFixedWidth(500);
   if(!openSqliteDatabase((QString&)defaultDatabaseName)) {
      statusBar()->showMessage(tr("File Database non aperto, errore."));
   }
}

"Without imperfection, you or I would not exist." ~Stephen Hawking

Go to the top of the page

chang112x

Beginner

Posts: 15

Occupation: Programmer and all sort of thing to survive.

Thursday, June 9th 2011, 7:07am

Ok Thank you very much ! Now is working quite perfectly !
One thing, how i can make the tableview area to expand to fill all the coloums, and scrollable ?

Thank you !