Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Update: Forum Guidelines & Code of Conduct

    Unsolved update row of one table with row inserted in other table SQLITE

    General and Desktop
    2
    2
    387
    Loading More Posts
    • 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.
    • F
      filipdns last edited by

      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

      jsulm 1 Reply Last reply Reply Quote 0
      • jsulm
        jsulm Lifetime Qt Champion @filipdns last edited by

        @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

        https://forum.qt.io/topic/113070/qt-code-of-conduct

        1 Reply Last reply Reply Quote 3
        • First post
          Last post