Hi,
First of all here the simple example of what i am doing would be:
-------------------------------- "SELECT id FROM test" Get first Result
DELETE FROM test WHERE id=xxx
Close Cursor ---------------------
When i call the DELETE command I get an error of TABLE LOCKED which for those that actually know something about the source code might understand, but not being to familiar about it I am not.
Now I know that some of you will reply with........... "Why not call the DELETE command with just the id's that we want to delete".
Well, esentially my program is not wanting to do that.......... without any further debates about it could we please discuss what we could do in this situation.
I read somewhere in the documentation about if a transaction fails for whatever reason then in the future the transaction will be retried after say the table has been unlocked.
Does this exist yet either in Beta development or something?
If not, any help with either solving this problem or telling me why it shouldn't be fixed would be of great help.
As I said I am not that knowledgable about SQLite but I see the error occurs from within a call to fileBtreeDelete 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.
Thanks in advance
Andrew -- Andrew Clark
