45.3.Writing values to SQL database
You can also use mySCADA to write new values or update existing ones in the SQL database. To do so, please follow these steps:
1. In the connection parameters, please fill in the SQL –> Write This query is a template for your write query; you can modify it anytime when specifying a new set command. However, it is convenient to prepare this template query so you don’t have to write it all over again.
2. Specify a set command
In set command, you can see your write query. This query will write values to the database. As you can see in the query, there is the keyword VAL; whenever you use VAL followed by a number, this VAL will be replaced with the real value provided as user input at runtime.
If you put multiple set commands into one Batch, they will be all processed as one query; in this case, you should have as many VAL keywords in your query as you have your sets in your batch.
For detailed information on how to work with set command and batches, please look at the corresponding chapter in this manual.