> On Jan 5, 2017, at 3:11 PM, Kyle <kmccord0...@gmail.com> wrote: > > Furthermore the PRAGMAs now seem to return a resultset whereas previously > they did not? Is this expected (or documented)?
That would explain the SQLITE_BUSY error — if the pragma returns a non-empty list of rows, and you’re not reading the rows or resetting the statement, the statement stays busy and will block closing the database. For this reason, if you’re running a query it’s a good idea to reset the statement afterwards, even if you weren’t expecting it to return any rows. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
