Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt
  • Unsolved
Collapse
qtws26_logo

The Qt Event of the Year: Qt World Summit 2026

Save Your Spot >
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. [SOLVED] How to store sql's ID and access it on QListView on click event to get this id?
Qt 6.12 LTS is out! See what's new in the release blog

[SOLVED] How to store sql's ID and access it on QListView on click event to get this id?

Scheduled Pinned Locked Moved General and Desktop
qlistviewqsqlquerymodel
2 Posts 2 Posters 1.7k Views 1 Watching
  • 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.
  • ? Offline
    ? Offline
    A Former User
    wrote on last edited by A Former User
    #1

    I have QSqlQueryModel model("SELECT name, id from x") and i've set it on listView->setModel(model)
    How can I fetch id from this model from

    void MainWindow::on_listView_doubleClicked(const QModelIndex &index)
    {
    
    }
    
    1 Reply Last reply
    0
    • Resurr3ctionR Offline
      Resurr3ctionR Offline
      Resurr3ction
      wrote on last edited by Resurr3ction
      #2

      I would do:

      int id = model->index(index.row(), 1).data().toInt();
      

      The sequence of the columns in the query is the same as in the model and the view so 0=name, 1=id. The model is obtained either directly from the class where you have it or from the view using QListView::model().

      1 Reply Last reply
      0

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt
      • Unsolved