Hello,

I have got two problems and I don't know how to repair to run correctly.

First problem:

Firstly I give some code.
Qt Code: 
  1. #include <QtGui>
  2. #include <QtSql>
  3.  
  4. #include "listresourcesdialog.h"
  5. #include "ui_listresourcesdialog.h"
  6.  
  7. void listResourcesDialog::initializeModel(QSqlQueryModel *model)
  8. {
  9.     model->setQuery("SELECT * FROM resources");
  10.     model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
  11.     model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
  12. }
  13.  
  14.  
  15. listResourcesDialog::listResourcesDialog(QWidget *parent) : QWidget(parent), ui(new Ui::listResourcesDialog)
  16. {
  17.     ui->setupUi(this);
  19.     initializeModel(&model);
  20.     ui->tableView->setModel(&model);
  21. }
  22.  
  23. listResourcesDialog::~listResourcesDialog()
  24. {
  25.     delete ui;
  26. }
  27.  
  28.  
  29. void listResourcesDialog::changeEvent(QEvent *e)
  30. {
  31.     QWidget::changeEvent(e);
  32.     switch (e->type()) {
  33.     case QEvent::LanguageChange:
  34.         ui->retranslateUi(this);
  35.         break;
  36.     default:
  37.         break;
  38.     }
  39. }
To copy to clipboard, switch view to plain text mode 

All is ok but when I called constructor of this class I saw table but there is nothing there. But if I give in:

Qt Code: 
  1. listResourcesDialog::listResourcesDialog(QWidget *parent) : QWidget(parent), ui(new Ui::listResourcesDialog)
  2. {
  3.     ui->setupUi(this);
  5.     initializeModel(&model);
  6.     ui->tableView->setModel(&model);
  7.     QMessageBox::information(this, tr("blabla"), tr("blalbla"));
  8. }
To copy to clipboard, switch view to plain text mode 

So I saw table with data from database, but if I accept QMessageBox (I click "OK") then data from table disappear. I don't know what is wrong and what can I do to run correctly.

Second problem:

Qt Code: 
  1. QSqlQuery query;
  2. query.prepare("SELECT * FROM profiles WHERE name = :name");
  3. query.bindValue(":name", ui->lineEdit_2->text());
To copy to clipboard, switch view to plain text mode 


All is ok, when this query has been executed I have in object results of this query, but I don't know how can I check how records are in objects (like numRows()) I have to know how many records are in this object.

Has somebody any solutions?