Randomly missing records when writing to SQL database Hello everybody,
I am using a Thing with MSSqlServer template to connect the system to a SQL database. The goal is to log PLC tag (binded to a Remote Thing) values, and store each under its relative database column.
I am using a simple SQL command to write these values into the database:
Spoiler (Highlight to read)
INSERT INTO *TableName* (Column1,Column2, ..., Column15)
VALUES ([[input1]],[[input2]], ..., [[input15]])
INSERT INTO *TableName* (Column1,Column2, ..., Column15)
VALUES ([[input1]],[[input2]], ..., [[input15]])
Together with another service linking each input parameter to my remote thing properties:
Spoiler (Highlight to read)
var params= {
input1: prop1,
input2: prop2,
...
input15: prop15
};
SQLcommand(params);
var params= {
input1: prop1,
input2: prop2,
...
input15: prop15
};
SQLcommand(params);
With this, I am able to ALMOST get what I want. In fact, when looking at what I am actually logging in the SQL database, it look
