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.

sqlite-users mailing list

Reply via email to