Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Single-line SQL comments in Information Link SQL get converted to multi-line format in TIBCO Spotfire Server
Solution:
One can add comments in the Information Link SQL in two ways:
Single-line comment:
The comment should end in a single line.
Multi-line comment:
Here, a comment can span over multiple lines.
The following screenshot gives an example of both the approaches.
This is done on purpose, to ensure that the generated SQL is more consistent, and using the multi-line(/* */) format since that is a wider supported standard.