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



  • 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 :)



  • 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.


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.