[SOLVED] SQL data source

This message was edited 1 time. Last update was at 25/07/2012 03:11:54

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"

Thanks

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

The '?' is the value parameter.

Thank you.