Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct
update row of one table with row inserted in other table SQLITE
-
Hello,
I have 2 tables sqlite and on each I have common name column "registration".
when I insert in the first table the drive time of the day, I have to increase the total time in the second table.
Could you help me?
thank you for your help
-
@filipdns It is not really a Qt question more a SQL question.
In SQL you can use triggers for that. See http://www.mysqltutorial.org/create-the-first-trigger-in-mysql.aspx
https://sqlite.org/lang_createtrigger.html
