Text from database to QStandardItemModel

[gabor53]

Hi @mrjj,
I tried the second solution first. When I used

QSqlTableModel *model = new QSqlTableModel();
model->setQuery ("SELECT Name FROM Item" );

I got the following error message:
C:\Programming\Projects\Folkfriends\mainwindow.cpp:42: error: no matching function for call to 'QSqlTableModel::setQuery(const char [22])'
model->setQuery ("SELECT Name FROM Item" );

What did I miss?

[mrjj]

@gabor53 said:
Hmm, even ?
QString q;
q="SELECT Name FROM Item";
model->setQuery (q);

[gabor53]

@mrjj
It gives the same error message for the

;
model->setQuery (q);

```line....

[mrjj]

@gabor53
hmm.
Do you have
QT += sql
in the .pro file?

[gabor53]

@mrjj

Yes, like this:

QT       += core gui sql

[mrjj]

@gabor53
and
#include <QSqlQueryModel>
?

[gabor53]

@mrjj

I have that one too.

[mrjj]

@gabor53
ok. no idea then.
http://doc.qt.io/qt-5/qsqlquerymodel.html

What version of Qt do you have ? did you compile yourself?

[gabor53]

@mrjj

I have 5.6 and Yes I compiled myself.

[SGaist]

Hi,

That's because you are using a QSqlTableModel, you should use a QSqlQueryModel.

QSqlTableModel goal is to make a table accessible.

[mrjj]

QSqlTableModel

Good catch :)

[gabor53]

@mrjj
The following worked:

	model = new QSqlTableModel(this);
    model->setTable ("Items");
    model->select ();
    ui->tableView->setModel (model);

Thank you for all your help!