Using QSqlQueryModel in QML without reimplement it [Solved]

luca

Hi all,
I'm starting with QML and I'm trying with a simple "example":http://developer.qt.nokia.com/wiki/How_to_use_a_QSqlQueryModel_in_QML.

Now I'd like to know if it's possible to use QSqlQueryModel without the need of subclass it.

andre

Yes, you can use QSqlQueryModel directly, but note that you can only access the first column of data.

luca

My qml file is:
@
import QtQuick 1.0
import Qt 4.7

Rectangle {
color: "lightblue"
Component {
id: name_delegate
Text {
text: "ciao"
}
}

ListView {
    clip: true
    anchors.margins: 10
    anchors.fill: parent
    model: queryModel
    delegate: name_delegate
}

}
@

in my main window constructor I have:
@
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);

QSqlQueryModel *queryModel;
queryModel = new QSqlQueryModel(this);
queryModel->setQuery("select descrizione from lista_dati;");

m_declarativeView = new QDeclarativeView(this);
m_declarativeView->rootContext()->setContextProperty("queryModel", queryModel);
setCentralWidget(m_declarativeView);
m_declarativeView->setSource(QString("qrc:rappresentazionegraficamagazzino.qml"));
m_declarativeView->setResizeMode(QDeclarativeView::SizeRootObjectToView);

}
@

How can I access the query column?

luca

No one can explain how to access QSqlQueryModel directly?

For me it's also usefull to have some documentation about...

DenisKormalev

As Andre said you can access only first column of data. To access all columns you need to subclass it and make all columns visible at first column via different roles.

andre

Then again, his query only returns a single column of data anyway, so that should not be a huge issue.

It seems to me at first sight, that what you are doing is correct. Perhaps "this page":http://doc.trolltech.com/4.7.1/qdeclarativemodels.html#qabstractitemmodel in the documentation is of help: you need to use the role names. The default role name for the DisplayRole is display.

luca

[quote author="Andre" date="1302851464"]The default role name for the DisplayRole is display. [/quote]

Thanks Andre. I needed this. Now It works.

Where should I find the role name you posted me in the documentation?

luca

[quote author="Luca" date="1302950174"][quote author="Andre" date="1302851464"]The default role name for the DisplayRole is display. [/quote]

Thanks Andre. I needed this. Now It works.

Where should I find the role name you posted me in the documentation?[/quote]

I found it in the link you posted...

antonio

Hi Luca, Andre someone may update the link that talks about role names? I'm facin the same problem.
thanks