The problem seems to be that sqlite is not recognizing
newline as a comment terminator (unless the comment
is alone on a line). I think you should write a bug
ticket; meanwhile, the work-around is to end your
comment with a semicolon.
sqlite select * from t1; -- comment
...
... ;
a
Hello Brown, Dave,
I don't receive any errors executing your SQL script with my SQLiteSpy database
explorer, which uses version 3.2.2 of the SQLite library.
Maybe you have accidentally inserted a newline into your script which
terminates the -- comment?
Regards,
Ralf
PS: SQLiteSpy home: