Is there any documentation available about savepoints? -- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/
On Jan 2, 2009, at 2:19 AM, D. Richard Hipp wrote: > > On Jan 1, 2009, at 7:25 PM, Igor Tandetnik wrote: > >> "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. > > > FWIW, nested transactions (in the form of SAVEPOINTs) will appear in > the next SQLite release, which we hope to get out by mid-January. The > SAVEPOINT code is already in CVS and is working well for all of our > tests so far, in case anyone would like to take it out for a test > drive. > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users