Setting QSqlTableModel from c++ to .qml tableView

[anda_skoa]

adding the columns makes no difference :/

Without columns it wil definitely be empty, because then you don't thell the view which property to show in which column.

And you forgot to post the code with coumns.

and QSqlTableModel is a subclass of QAbstractTableModel... is that wrong?

So object is a plain QSqlTableModel not some application specific subclass?

Cheers,
_

[heczaco]

Well, for the columns I tried many ways, with rolenames with rolenames equal as the ones i'd get if I create the table from c++ (as in the code in the original post), with titles, no titles, etc. None seems to work :/

TableView{
            id: table;
            width: parent.width -100
            height: parent.height -200
            anchors.horizontalCenter: parent.horizontalCenter
            anchors.top: parent.top
            anchors.topMargin: 90
            model: eventModel.getTData(GData.tName, table);
            TableViewColumn{
                role:"time"
                title:"time"
            }
            TableViewColumn{
                role:"var1"
                title:"var1"
            }
            TableViewColumn{
 
            }
            TableViewColumn{
                role:"var3"
            }
        }

TableView{
            id: table;
            width: parent.width -100
            height: parent.height -200
            anchors.horizontalCenter: parent.horizontalCenter
            anchors.top: parent.top
            anchors.topMargin: 90
            model: eventModel.getTData(GData.tName, table);
            TableViewColumn{
                role:"time"
                title:"time"
            }
            TableViewColumn{
                role:"var1"
                title:"var1"
            }
            TableViewColumn{
    
            }
            TableViewColumn{
                role:"var3"
            }
        }

To copy to clipboard, switch view to plain text mode 

The table model is a plain QSqlTableModel, does the problem lie in there?, 'cause it seems to work just fine for a table created in c++

Capture.jpg

[anda_skoa]

The only roles you have are the ones defined in QAbstractItemModel, e.g. "display".
None of your columns use existing role names, so it is no suprise that the table is empty.

Cheers,
_

[heczaco]

thanks, in debug time I saw that the role names were totally different to the headers (I thought set headerdata would change both) it shows data now that I change the roles to the names I saw on debug time, but I'm not able to set the roles from c++ to what I want, could you help me get in the right direction?

[anda_skoa]

QAbstractItemModel::roleNames() allows you to map custom roles name to custom role values.

So you specifiy some integer role values for the data you want to get (usually usign an enum) and then map these values to the strings that you want to use on the QML side.

Cheers,
_

[heczaco]

Hi, I'm only able to display the first column with the Display Role, Can I only use that role? If so, how do I get the other columns to show?

[anda_skoa]

Hi, I'm only able to display the first column with the Display Role

Unsurprisingly, since that is one of the standard roles that is also in the standard role name mapping.

Can I only use that role?

Of course not, that would make models pretty useless.

If so, how do I get the other columns to show?

See comment #10.

Cheers,
_