• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    [SOLVED] SQL data source

    User help
    2
    4
    2.0k
    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.
    • T
      tiago156
      last edited by

      Hi,

      I'm configuring a SQL point and it have one parameter called "Update statement" (attachment), how it works?

      Can i create a UPDATE/INSERT using the value that the user set?

      Example: user on watch list set a point to 25, how can i put this value on the SQL, i need to use some environment variable? like VALUE or TIMESTAMP?

      update table set column1 = ?VALUE?, column2 = ?TIMESTAMP?
      where column3 = "test"

      image

      Thanks

      1 Reply Last reply Reply Quote 0
      • M
        mlohbihler
        last edited by

        Only the value is used, not the timestamp. Your insert/update statement might look like this:

        update table set column1=? where column3='test'
        

        The '?' is the value parameter.

        Best regards,
        Matthew

        1 Reply Last reply Reply Quote 0
        • T
          tiago156
          last edited by

          Thank you.

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