Named Query parameter clash with comments line. Generates error "index out of range"

Ignition
1

Hi,

I’m a beginner in SQL. Not sure this is a bug or expected result.
On a named query, when I make a code line as comments with ‘–’ , the parameter inside the comment line clashes with same parameter in actual code.
I hope anything followed by “:” is considered as parameter irrespective of comment line

I was struggling long time to find this out!!!

image
image918×283 14.4 KB

1 Like
2

Don’t use comments. Ignition uses a JDBC driver to talk to your database, and only strict SQL is generally supported. Running in your database’s workspace is not equivalent–those generally accept a scriptable superset of SQL, and comments are considered scripting by most DBs.

3

Thanks for prompt response. Noted your advice.