SQL Query Exception For WHERE Filter With Parameter

Question

question

Arun Kr asked Apr 26, '22 Jason Lightfoot answered Apr 26, '22

Hi Support,

SQL query throwing exception for WHERE filter with parameters, while debugging. Is this a known issue? Or am I doing a mistake here?

Note: Error happens only when we do debugging and not happening for non-parameter conditions

string x= "A";
Table Q = Table.query("SELECT * FROM GlobalTable1 WHERE Type = $1",x);

return Q[1][2];

exception: SqlQuery - Unknown error in: SELECT * FROM GlobalTable1 WHERE Type = $1

Regards,

Software Version:

FlexSim 22.1.1

Answer 1 · 2022-04-26T11:19:29Z

Jason Lightfoot answered Apr 26, '22 Arun Kr commented Apr 26, '22

Yes - thanks for posting. This is a known bug that has been reported elsewhere.