Setting QSqlTableModel from c++ to .qml tableView



  • I have a tableview on a qmlfile, I'm trying to set the model from c++.

    The model I'm using is QSqlTableModel, if a create a new tableview and set the model from c++ it seems to work, but when I pass the model to the model property in the qmlfile it doesn't work and I can't figure out why...

    the c++ model code is:
    QSqlTableModel * SqlEventModel::getTableData(QString tableName, QTableView *item){

    	const QString queryStr = "SELECT sql FROM sqlite_master WHERE tbl_name = '" + tableName +"' AND type = 'table'" ;
    	QSqlQuery query(queryStr);
    	if (!query.exec())
    		qFatal("Query failed");
    
    
    	QSqlDatabase db = QSqlDatabase::database(":memory:");
    
    	QSqlTableModel *model = new QSqlTableModel(item, db);
    	model->setTable(tableName);
    	model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    	model->select();
    
    
    	int i=0;
    	while (query.next()){
    		model->setHeaderData(i, Qt::Vertical, query.value(i).toString());
    		i++;
    	}
    
       return   model;
    
    }
    

    that returns a model which works if within c++ I create a tableview and assign the model but when I do this:

    TableView{
    	id: table;
    	width: parent.width -100
    	height: parent.height -200
    	anchors.horizontalCenter: parent.horizontalCenter
    	anchors.top: parent.top
    	anchors.topMargin: 90
    	model: SqlEventModel.getTableData(GData.tName,table)
    }
    

    it doesn't work, it just shows an empty table even though when I debug the tableview model is not empty...

    if I add:

    QTableView *view =  new QTableView();
    view->setModel(model);
    view->show();
    

    just before the return on the c++ function I get a new window with a table which properly displays the table... I tried adding columns with the same rolename that I give in c++ and they won't populate either.... here's a screenshot of both tables

    http://i.stack.imgur.com/gGzhu.png


  • Lifetime Qt Champion

    Hi and welcome to devnet,

    To make models accessible to QML you have to do sum customization like described in the QtQuick Model Views Data documentation.

    QSqlTableModel example here


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.