On 29 Mar 2012, at 4:38pm, Randall Kuchik <rmks...@gmail.com> wrote:

> I get the incomplete SQL error when I attempt to run DML command in files
> (INSERT, UPDATE, DELETE, SELECT) using the .read command.  I am able to run
> any DDL statements I try (CREATE, ALTER, etc.) with no problem.  I am using
> SQLite 3.7.11 on Windows XP.
> sqlite> .read x5.txt
> Error: incomplete SQL:  ■I
> sqlite>

Do your SQL commands end with a semicolon ?  e.g.

SELECT * FROM myTable;

Try typing one of the commands (for example an INSERT command) rather than 
using .read to read it from a file.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to