question

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