On 16 Jul 2013, at 11:24pm, Loren Keagle <loren.kea...@braemarllc.com> wrote:
> Begin EXCLUSIVE TRANSACTION; > insert several rows of data; > Commit transaction; > > Prepare query statement; > Iterate through one or more rows; > Reset statement; > > Attempt to begin transaction; <--- SQLITE_BUSY!!!! > Would like to write more here, but can't unless I close/open the connection; I assume you're checking the result codes returned by all the API calls before the second BEGIN to see that they all return SQLITE_OK. Please add a _finalize() after the _reset() just for testing purposes. I know you may not want it as part of your production code. Is the statement that gets a busy a BEGIN or BEGIN IMMEDIATE or BEGIN EXCLUSIVE ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users