Just an annoyance I can't find , I thought someone here might know.
In a new script library I created I have lots of def procedures, and only 3 are showing in the pane to the right where you can click on to navigate to. I can't find the difference from those that are showing. I have a few other script libraries and all of those def procedures always show.
What is it that makes them available and show there, what might be wrong here? (Ignition 8.1.47). Thanks.
Syntax error somewhere, or mixed tabs/spaces. You should be able to toggle the display of whitespace characters in the editor.
Side note, your current method of creating a SQL query is leaving you open to SQL injection. Prep queries are normally constructed using ? as a value placeholder, and provided a list of values when calling runPrepUpdate/runPrepQuery that are used to fill in the ? in the order they appear in the query.
3 Likes
Yes, that was it, tab after the def (my copying and pasting, sigh). Thank you.
(And thanks for the sql advice)
Not to mention being a pain in the butt to construct with so many concatenations! Using the query params also handle type conversions