1) Can parameters be used for writing multiple rows to a table? (rather than the step method)
Guessing the answer is to use a loop for multiple parameter values.
To expand, somehow the variant data is substituted into the SQL statement. So I'm writing two fields to a table, and I provide an array with multiple rows of two columns. The data from each row is put into the table. I tried something like this, "insert into directory (directoryname,directorypath) values (?,?) ", and the ? are replaced with rows in the parameters variant input. (doesn't work of course) 🙂
Semi answered. I can parameter input one row, using two strings, and it works, relatively intuitive. But I was hoping this could be used to enter multiple rows too, without loops to pull from an array and then separate into strings or insert into clusters. (Feeling greedy am I)
In the image, the highlighted structures don't work, but the cluster does.
2)I'm guessing the one row array doesn't work as the datatype is not an array, and there are two fields but only one array (datatype). Does this sound more or less correct?
Noticed the example is broke in LV2020.
Also, noticed the example is broken in LV2020.