Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Update: Forum Guidelines & Code of Conduct

    Solved How to show QSqlQuryModel in QML?

    QML and Qt Quick
    qsqlquerymodel tableview sql qml
    3
    3
    570
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • noone
      noone last edited by

      I want to show QSqlQuryModel in qml TableView but I don't Want to create separate QML file for each new query cause I can't create infinite qml files as given here . Also question is not working for me for dynamic number of columns (could be version difference as I am using 5.11) .I just want something like:-

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

      in QML.

      I am new to qml . So far I am able show QsqlQueryModel as guided in first link but my user may enter any SQL Query

      1 Reply Last reply Reply Quote 0
      • ODБOï
        ODБOï last edited by

        This post is deleted!
        1 Reply Last reply Reply Quote 0
        • SGaist
          SGaist Lifetime Qt Champion last edited by

          Hi,

          Add a setter to your model that is Q_INVOKABLE and pass your query through it. Don't forget to add proper error checking to give feedback to your user if something goes wrong.

          Interested in AI ? www.idiap.ch
          Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

          1 Reply Last reply Reply Quote 1
          • First post
            Last post