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. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
