Hey, I created different OPCU-Items to read Values from my PLC and store them in an Microsoft SQL Database.
If I use only one Item, read it with the OPCUA Client an write it to the Database with MSSQL-PLUS, everything is working. But if want to repeat it for more variables at the same time, I dont know how to adress them right.
This is the query(MSSQL-PLUS) I use at the moment to write to my Database for just one variable.
DECLARE @value NUMERIC
SET @value = {{payload}};
INSERT INTO LISTHADaten(StatusID,Uhrzeit)VALUES(@value,CURRENT_TIMESTAMP);
I think a good solution could be that I use the Client with the Action MULTIPLE READ and store the variables in an array, so I can adress them in the SQL Query and write each on to the right column. But I don't know how to get this array.