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

  • 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


  • 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.


  • Thank you.