Re: [sqlite] Table locked when trying to delete a record whilst a cursor to the table is open

those being queried. Hi, Thanks I think I will indeed use a temporary table instead. It will probably use less memory and less hassle than me caching all the results myself. Thanks again Andrew -- Andrew Clark

Re: [sqlite] Table locked when trying to delete a record whilst a cursor to the table is open

cache the objects to be deleted into a list and then destroy them at the end of the enumerator. It's a pity it couldn't have been implemented in SQLite though to be more flexible. Thanks anyway Andrew -- Andrew Clark

[sqlite] Table locked when trying to delete a record whilst a cursor to the table is open

was deleted after it had encountered that record. Andrew -- Andrew Clark

[sqlite] Table locked when trying to delete a record whilst a cursor to the table is open

eDelete which itself is called from the OP_DELETE part of vdbe Could someone please tell me if this is a simple thing to solve, and even if whether it should be solved or not. I may indeed look at changing my app design to call DELETE commands directly if this cannot be resolved quickly. Than

[sqlite] Please confirm this is a bug !

be the SQL interpreter is reading the BEGIN (start a transaction) but not reading the rest of the commands when an error occurs and therefore doesn't see the COMMIT (end transaction) at the end. Andrew -- Andrew Clark