Comments in Queries

[adminboy]

Hi there,

How do I put comments in the SQL queries in the Report Source?

Thanks,
Adminboy

[Support]

The SQL syntax for a comment is to start a line with '--' (without the quotes). However, due to our extended SQL parsing, this only works if you put the '--comment' at the end of the SQL query...

Code: Select all

select x, y, z
from atable
order by x;
-- some comments here

As an alternative, you could use the REPORT NOTES field to make notes about the SQL.

[adminboy]

Thanks.