SQL Data Source Insert and Update rows

[Ralf]

Hi,

if I want to insert new values or update values in a mySQL table it works for me with single values (=?), set via Meta Data Source point:

INSERT INTO table_xz (
IDNr, ValveNr, LineNr, StartTime) 
VALUES (?,'KS0717','B',NOW())

But if I want insert more then one ?:

INSERT INTO table_xz (
IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime) 
VALUES (?,?,?,'KS0717','B',NOW())

How can I set the second or third ? via script or meta data point?
My solution with an alphanumeric mds-point doesn't work:

var myVar = myIDNr.value + ',' + myStartSum.value + ',' + myStartTemp.value;
var myString = myVar.toString();
print(myString)
if ( myStart.value == true )
    mySQL.set ( myString.value );

What is the best solution?

Thanks for your help.

[MattFox]

@ralf said in SQL Data Source Insert and Update rows:

INSERT INTO table_xz (
IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime)
VALUES (?,?,?,'KS0717','B',NOW())

I know you can extend the insert query by just adding another batch of values after in brackets.

INSERT INTO table_xz (
IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime) 
VALUES (?,?,?,'KS0717','B',NOW()),(?,?,?,'KS0717','B',NOW())

You may need to insert the actual values though.