Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. QML and Qt Quick
  4. [SOLVED]How to access sqlite rowid
Forum Updated to NodeBB v4.3 + New Features

[SOLVED]How to access sqlite rowid

Scheduled Pinned Locked Moved QML and Qt Quick
2 Posts 1 Posters 2.1k 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.
  • B Offline
    B Offline
    belab
    wrote on last edited by belab
    #1

    Hi,
    I have a LocalStorage with a table created with tx.executeSql('CREATE TABLE IF NOT EXISTS Cards(one TEXT, two TEXT)');
    Now I'm trying to update the model with:

    var rs = tx.executeSql('SELECT * FROM Cards');
    model.clear()
    for(var i = 0; i < rs.rows.length; i++) {
    var item = rs.rows.item(i);
    console.debug("update", item.rowid);
    model.append({"rowid":item.rowid, "one": item.one, "two": item.two});
    }
    

    But I'm just getting the output qml: update undefined
    Does someone know how to access the implicit sqlite rowid?
    Thanks in advance.

    B 1 Reply Last reply
    0
    • B belab

      Hi,
      I have a LocalStorage with a table created with tx.executeSql('CREATE TABLE IF NOT EXISTS Cards(one TEXT, two TEXT)');
      Now I'm trying to update the model with:

      var rs = tx.executeSql('SELECT * FROM Cards');
      model.clear()
      for(var i = 0; i < rs.rows.length; i++) {
      var item = rs.rows.item(i);
      console.debug("update", item.rowid);
      model.append({"rowid":item.rowid, "one": item.one, "two": item.two});
      }
      

      But I'm just getting the output qml: update undefined
      Does someone know how to access the implicit sqlite rowid?
      Thanks in advance.

      B Offline
      B Offline
      belab
      wrote on last edited by
      #2

      @belab
      Found it:var rs = tx.executeSql('SELECT rowid, * FROM Cards');

      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 Extensions
      • Unsolved