Hello Helical Insight,
Why is it that a query is working in DBvisualizer but it is not working at Helical Insight view level? I am using PostgressDB, version 5.0 of Helical Insight EE.
Thank you,
Cokaw.
Hello Cokaw,
Please remove the semi-colon(that is highlighted in yellow color) present at end of your query as shown in the screenshot below. The same semi-colon is highlighted in the Error message also. After that again run SQL view without changing anything else. In our view, we do not need semicolon at the end and comments.
Thank you,
Helical Insight.