Has anybody else discovered that placing comments in your dataset SQL can cause BIRT exceptions?
I've tried all of the following different syntaxes but the only way to make BIRT happy was to remove them altogether:
/* Get total revenue per month based on the parameter
/* Get total revenue per month based on the parameter */
--Get total revenue per month based on the parameter
Just one example of a problem I've encountered which I've managed to solve by removing the comments is: When I tried to "Preview Results" I was getting the BIRT exception 'missing mandatory parameter'. This doesn't usually happen as I've coded plenty of these. The only way I could preview was to remove the comments. This doesn't really make sense to my logic
I've had other examples of errors solved by removing comments, but haven't recorded them. I'll add to this thread as I encounter them.
The other reason for posting this is that I haven't been able to find a similar post so this might help others that encounter this.
