Re: [sqlite] Re: UPDATE during SELECT

have not suffered a performance hit yet. Using a mutex alone restricts concurrent reading, not a good idea. Larry Lewis wrote: > Igor, > > Thanks for your help. I've tested the first case successfully. > > For a multi-threaded application using an in-memory database ("

Re: [sqlite] Re: UPDATE during SELECT

question below will be quite common (SELECT a group of records and make UPDATEs as I step through them). Larry - Original Message ---- Larry Lewis wrote: > If I am stepping through the results of a SELECT and want to UPDATE > values in the currently selected row prior to completion

[sqlite] UPDATE during SELECT

If I am stepping through the results of a SELECT and want to UPDATE values in the currently selected row prior to completion of the SELECT query, will this work? What if there is already a pending writer lock on the database from a different thread? Thanks. Larry ---