"Webb Sprague" <webb.spra...@gmail.com> wrote in message news:b11ea23c0901011622i23f7b583wd05f07104dd06...@mail.gmail.com > I have a script containing the following, which works fine except that > at the end of the script I get "SQL error near line 5: cannot commit - > no transaction is active". The table specified in the file on line 2 > gets created just fine, and populated just fine on line 4. I am using > sqlite 3.6.7, custom built with new column limits and variable limits.
I suspect .import directive invokes BEGIN and COMMIT internally. SQLite transactions don't nest. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users