aurelius
12th October 2011, 22:39
Hi,
my application connects to a MySQL database, which is externally updated by users and also by my software. However, I do need
1) a trigger, signal or something similar, so that I get to know when a change has been done
2) a list of the changes
I need those two information, so that I can afterwards update the database myself with information related to the changes caster from the users. I found a couple of general solutions for submitting a SQL query, however the QSqlQuery seemed to have problems with multi-line queries.
Do you know how this can be done elegantly and efficiently?
my application connects to a MySQL database, which is externally updated by users and also by my software. However, I do need
1) a trigger, signal or something similar, so that I get to know when a change has been done
2) a list of the changes
I need those two information, so that I can afterwards update the database myself with information related to the changes caster from the users. I found a couple of general solutions for submitting a SQL query, however the QSqlQuery seemed to have problems with multi-line queries.
Do you know how this can be done elegantly and efficiently?