SQLite Forum

table locked when dropping a temp table
Login
That's good information already.

The easy test is now to take the script as-is, but substitute the parameters with some actual values so that it can be run multiple times using the sqlite3.exe (or whatever CLI you use) and also run it again through the ZeosDB component like that.

Either both of these fail, or both work, or one fails and one works. Either way we will know what is wrong.

- If both fail, and it can be made to fail for other people, then there is a bug in SQLite or at least the VFS it uses on your system.
- If Zeos fails and not SQLite, then there is a bug in the ZeosDB system.
- If SQLite fails and not ZeosDB - we'll all die of surprise.

If it does fail on both - Post the actual DB file (or if it has sensitive info, at least a version of it that has some info obscured but still causes the error).

If CLI's are not your favourite thing, depending on your OS you can use some GUI like SQLitespeed or DB Browser for SQLite (just Google them), both of which are not the final say on anything SQLite-esque, they do however use the API directly and provide error reporting, so an error in them will also provide more clues.


PS: I realize that your problem is technically already solved, but if you are really interested in finding out the reason of the failure - proper debugging is the way to go, and, if it turns out to be an SQLite bug, you'll get some kudos too.