http://forum.infiniteautomation.com/forum/posts/list/3.page JForum - http://www.jforum.net
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"


[IMG]http://i45.tinypic.com/294nsic.png[/IMG]

Thanks]]> http://forum.infiniteautomation.com/forum/posts/preList/1168/4935.page http://forum.infiniteautomation.com/forum/posts/preList/1168/4935.page GMT
[code]update table set column1=? where column3='test'[/code]

The '?' is the value parameter.

]]> http://forum.infiniteautomation.com/forum/posts/preList/1168/4947.page http://forum.infiniteautomation.com/forum/posts/preList/1168/4947.page GMT http://forum.infiniteautomation.com/forum/posts/preList/1168/4949.page http://forum.infiniteautomation.com/forum/posts/preList/1168/4949.page GMT