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.