Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. QSqlQueryModel and QTableView
Forum Updated to NodeBB v4.3 + New Features

QSqlQueryModel and QTableView

Scheduled Pinned Locked Moved General and Desktop
1 Posts 1 Posters 853 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.
  • C Offline
    C Offline
    cardfour1
    wrote on last edited by
    #1

    I have a sqlite database that is associated with a QSqlQueryModel and TableView. I also have a QTimer that executes the SqlQueryModel every 1-10s to poll the database ( not sure if this is the cleanest solution, but it works). I'm noticing that the database is constantly locked, even if I up the timer to 30 seconds. After reading
    some on-line documentation, I decided to call the SqlQuery::finish method after executing the query, this seems
    to un-lock the database, but I loose the information stored in my TableViews.

    Does anyone know why this is occurring ? Also, is there a better way of updating the TableView if an external event writes to the sqlite database ?

    Thanks.

    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