Dynamic SQL Tools?

[aedcce]

I want to love dynamic SQL. I really do. But I feel like I must be missing some tooling, because the way I am doing it has absolutely no assist. Not even syntax highlighting!

I have to be doing this wrong, right?

How are you guys writing dynamic SQL with any convenience?

[AdamWoodlandToo]

Sadly not that I know of, I still have to refer to https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Accessing-Data-via-SQL-in-Structured-Text/ba-p/... when I do it, I wrote that article 15 years ago to help me do the SQL

The way that the SQL is implemented in ST is crazy powerful though, just got to be careful not to use it too much to cause system issues.

Would be really good to have some better syntax highlighting and autocompletion in ST, but I'd still prefer something like a python was added as a similar server-side function which hopefully would automatically come with those.

[gabarit · Accepted solution]

Hi
In the Online and Local Help:
https://tprojects.schneider-electric.com/GeoSCADAHelp/Geo%20SCADA%202022/Default.htm#LogicGuide/Usin...