On 14 Jun 2010, at 3:43pm, Robert Latest wrote: > On Mon, Jun 14, 2010 at 4:36 PM, Simon Slavin <slav...@bigfraud.org> wrote: > >> Do you mean you're making changes as you call SQLite to _step() through the >> results of the SELECT ? Or do you read all the results of the SELECT into >> memory, then make changes to the database ? > > The former.
Right. Well, the SELECT command is creating its own TRANSACTION, and that TRANSACTION lasts until you have finished stepping through its response. So that needs to be considered as a reason for your LOCKED, as if you have two simultaneous database users. Simon. _______________________________________________ sqlite-users mailing list email@example.com http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users