Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
For loading data from databse tables I use exteranal sql-script files attaching it like this:
$(Include=rows.sql);
Before start loading I debug query in Database Query Analyser.
The problem is in comments. SQL comment style looks like:
-- My Comment
But signs "--" cause error in QlikView.
QlikView comment style "//" causes error in SQL Query Analyser.
How can I write comments in external sql-script so that still work in Query Analyser?
Hi
I am not sure how you are using this particular include file, but it is no different than anywhere else in the script. Statements executed by SQL server (ie after a SQL statement up to the closing ; sign) need -- SQL comments, and all other statements need // QV comments.
HTH
Jonathan
Hi
I am not sure how you are using this particular include file, but it is no different than anywhere else in the script. Statements executed by SQL server (ie after a SQL statement up to the closing ; sign) need -- SQL comments, and all other statements need // QV comments.
HTH
Jonathan
Hi,
maybe you could use the /* */ notations.
Hi Pavel,
You can use find and replace functionality and replace all -- with // in your external script.
Thanks & Regards
Suhas Gupta
Thank you very much Jonathan!
It realy works!
Michele Barini wrote:
Hi,
maybe you could use the /* */ notations.
Good suggestion - that would also work.