[sqlite] Under what circumstances can a table be locked when the database is first opened?

[Simon Slavin]

On 23 May 2015, at 4:13am, david at andl.org wrote:

> Run it once and it works perfectly. Run it twice and the DROP TABLE triggers
> the error:
> 
> SQLITE_LOCKED, database table is locked

I suspect Keith has it right.  To help you figure out which of his options is 
right,

Run it once.  Stay logged in for an hour.  Run it again.

Does it work now ?

Simon.