bug ? comment lines in script make next statement to be also a comment

User, date Message
Written by emordant
3 years ago
Category: Running SQL scripts
1 posts since Sun, 06 Mar 11
I used HS v5.0.0.3272 and it worked like a charm with SQL scripts.
After an update to v6.0 stable, the comment lines in my script doesn't seems to 'understand' the end of line.
The color syntax of the script loaded is ok : grey for comment lines begining with # or -- and the lines after are correctly colorized (keywords insert, update delete are well recognized)
But when running the script, every statement lines who follow a comment line seems to be added at the end of the comment line, and so, is not executed, and the first statement really executed is the 2nd statement after the comment line.
It is possible to work arround this problem by inserting a new line with only a semi colon, after each comment line.
Editing my scripts with notepad++ shows me corrects CRLF at each end of lines and update to nightly build doesn't change anything.
Downgrading to v5.0.0.3272 solves the problem.
I forgot something ?
Written by brazil
3 years ago
16 posts since Thu, 27 Jan 11
You forgot to try the latest build, 6.0 is so outdated ...
Written by ansgar
3 years ago
4784 posts since Fri, 07 Apr 06
Yes, please update - although I don't recall some recent change in the SQL splitter. If it does not solve that problem - could you please post some non working SQL snippet here?

Please login to leave a reply, or register at first.