Re: [sqlite] Problem with sqlite3_interrupt on Windows

John Machin wrote: > On 10/06/2009 4:40 AM, Jeremy Smith wrote: > >> When I run sqlite3_interrupt, it doesn't close existing file handles, >> making further searches tricky. >> > > Which handles? How do you know? What does "tricky" mean -- "di

[sqlite] Problem with sqlite3_interrupt on Windows

When I run sqlite3_interrupt, it doesn't close existing file handles, making further searches tricky. So I wrote code which clears all normal file handles (fopen in shell.c), but... How do I close the database file too? It's not opened using fopen, but with CreateFileA (in winOpen in os_win.c)

Re: [sqlite] Terminating a query

Nuno Lucas wrote: > On Tue, Jun 9, 2009 at 1:53 AM, Jeremy Smith<jer...@decompiler.org> wrote: > >> I'm running SQLite in a thread. If the user hits 'Cancel' in my GUI, I >> want (notified by setting a flag variable) SQLite to stop the query and >> shut do

[sqlite] Terminating a query

I'm running SQLite in a thread. If the user hits 'Cancel' in my GUI, I want (notified by setting a flag variable) SQLite to stop the query and shut down gracefully. I tried closing the thread with TerminateThread, but the database cannot be queried after this, and the entire program has to be