Forum Discussion
ChristianW
3 years agoValued Contributor
Maybe it is just a typo?
Appendline() is quite unhandy for long sql statements. Alternatively, you can store the sql in a file (in a dashboard file, or in OS file structure) and access it via a BrApi call.
- JackLacava3 years agoCommunity Manager
I worked with his query in SQL Studio, removing the WHERE clauses, and it runs. Runs also in SQL Data Adapter. Then I dropped it into an executeSql call and I got his error. I guess it's some funky option our wrapping api sets, and we have no way to override it.
Related Content
- 8 months ago