I am using a database to store data from Rapid Scada. I want to save the value of an input into a table.
In order to do this, I have created an output with a formula that references the value I want to save. It has the same command number as that the one I defined in the driver. The problem is that, when I send a command, the value saved is whatever value is written in the command, instead of the result of the formula.
The SQL code I am using for the command is:
INSERT INTO data (Counter1) VALUES (@cmdVal);
So, my question is: How can I write the result of a formula in a MySQL database?
This topic was modified 2 years, 10 months ago by Mikhail.