Re: [sqlite] Terminating a query

Nuno Lucas wrote: > On Tue, Jun 9, 2009 at 1:53 AM, Jeremy Smith 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 down gracefully. I tried closing the

Re: [sqlite] Terminating a query

On Tue, Jun 9, 2009 at 1:53 AM, Jeremy Smith 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 down gracefully. I tried closing the thread with TerminateThread, >

[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

Re: [sqlite] Terminating long query in C ?

"Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > > Another way is to use sqlite3_interrupt. Before SQLite 3.3.7 (which I > believe is the latest version at this time) 3.3.8 was released yesterday (Monday) morning. I have not sent out an official announcement on this mailing list. Sorry. >

Re: [sqlite] Terminating long query in C ?

Mohd Radzi Ibrahim wrote: How do I cancel a long running query? In OLEDB I can call pICommand->Cancel() from a different thread to kill the running query. How can I do the same in SQLite? Radzi, See http://www.sqlite.org/capi3ref.html#sqlite3_interrupt for information on

[sqlite] Terminating long query in C ?

Hi, How do I cancel a long running query? In OLEDB I can call pICommand->Cancel() from a different thread to kill the running query. How can I do the same in SQLite? thanks. Radzi.