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. MS SQL Server and QT: get Signal in QT Aplication when Data in SQL Server changed
Forum Updated to NodeBB v4.3 + New Features

MS SQL Server and QT: get Signal in QT Aplication when Data in SQL Server changed

Scheduled Pinned Locked Moved General and Desktop
2 Posts 2 Posters 890 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.
  • M Offline
    M Offline
    M001
    wrote on last edited by
    #1

    Hallo,
    I want to connect my QT Programm with a MS SQL Server Database. This works allready, I can read and write into the Database from my application. Now I want to get informed in my QT Application, when the Data of the SQL Database has changed. Is there a Signal I could use to get a trigger when the content of the Database changed. Or are there other solutions for this problem?

    Thank you for help :)

    1 Reply Last reply
    0
    • H Offline
      H Offline
      hardcodes.de
      wrote on last edited by
      #2

      AFAIK the database server won't inform clients about data changes. So Qt can not inform your code.
      But you could build a trigger inside the database, write the info that data has changed into to a separate table and poll that via QTimer every now and then.
      At that point you could emit a signal.

      while(!sleep){++sheep;}

      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