On 2006-01-13, Tom Hawkins
I have HDBC running with Sqlite3, but I'm getting a SqlError due to a locked table. Please excuse my SQL ignorance, but what may be causing the problem? In SQL, are we not allowed to select, update, and delete from a table within a single transaction? If not, what are the rules for transactions?
Sqlite3 has some restrictions that most (all?) other SQL databases don't have. One critical one is that, with a few exceptions, you are not allowed to have more than one statement open on a given database simultaneously. This has bitten me a few times as well. I suspect that you may simply need to call finish on your statement after you're done with your query. This would be the most critical on your updates (INSERT and UPDATE queries). If you post your code, I could probably point out specific problems. -- John