2009/11/20 Norbert <[email protected]>: > Hi, > > I use SQLite 3.6.16 on Ubuntu Linux Karmic Koala, installation via > normal Ubuntu repository. At home (Linux) and also in the office > (Windows XP), I encountered the following problem. > > Source of test.sql: > > *****BEGIN OF SOURCECODE******** (next line is line 1) > .headers off > > > /* > Here comes the comment. Source is reduced to show core of the problem. > */ > > .mode column > > SELECT * from tab1; > > > > *****END OF SOURCECODE********** > > > Now, I have a sqlite database with one table tab1. When I do the > following: > .read test.sql > > I get the following error: > SQL error near line 4: near ".": syntax error > > The ".mode column" after the comment block can be replaced by other > Non-SQL statements, and you will get the same error. When after the > comment block, there is directly a SQL statement, there is no error. > > I have the feeling that there is a problem of the SQLite parser dealing > with a mix of comments and SQLite-specific commands. >
comment lines in sql begin with -- Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
