Hello,
I was trying to do an query on a GlobalTable and my params are data into an array. The number of parameters are variable, so there is a way of "descontruct" the array into the params?
Ex:
Array arr = ['par1', 'par2', 'par3'];
Table result = Table.query("SELECT * FROM GlobalTable1 WHERE Col1 = $1 AND Col2 = $2 AND Col3 = $3", arr);
In the example above, 'par1' should enter in $1, 'par2' in $2 and so on.
It could be done like this:
Array arr = ["par1", "par2", "par3"];
string queryString = "SELECT * FROM GlobalTable1";
// build variable length query
if (arr.length > 0) {
queryString += " WHERE ";
for(int i = 1; i <= arr.length; i++) {
queryString += "[Col " + i + "] = $1[" + i + "]";
if (i != arr.length) {
queryString += " AND ";
}
}
}
// makes a string like this "SELECT * FROM GlobalTable1 WHERE [Col 1] = $1[1] AND [Col 2] = $1[2] AND [Col 3] = $1[3]"
Table result = Table.query(queryString, arr);
16 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
