SQL Query Exception For WHERE Filter With Parameter

[arunTTT2P]

[ FlexSim 22.1.1 ]

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,

Arun KRSQLQuery_WHEREFilterException_Bug.fsm

[jason_lightfootVL7B4 · Accepted solution]

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