"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

Reply via email to