Re: [sqlite] sqlite3_interrupt() and threads

Am 26.07.2006 um 01:06 schrieb [EMAIL PROTECTED]: Michael Scharf <[EMAIL PROTECTED]> wrote: Rob, I notice in the documentation that the sqlite3_progress_handler() method is marked "experimental". Is that significant? No idea, that's a question Richard Hipp may answer.. I need to remov

[sqlite] unsubscribe me please RE: [sqlite] sqlite3_interrupt() and threads

Chunde Shi [EMAIL PROTECTED] 703 882 1466 703 882 2325 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 7/25/2006 7:06 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3_interrupt() and threads Michael Scharf <[EMAIL PROTEC

Re: [sqlite] sqlite3_interrupt() and threads

Michael Scharf <[EMAIL PROTECTED]> wrote: > Rob, > > I notice in the documentation that the sqlite3_progress_handler() method > > is marked "experimental". Is that significant? > > No idea, that's a question Richard Hipp may answer.. > I need to remove the experimental marking. Perhaps somebod

Re: [sqlite] sqlite3_interrupt() and threads

Rob, I notice in the documentation that the sqlite3_progress_handler() method is marked "experimental". Is that significant? No idea, that's a question Richard Hipp may answer.. Michael -- http://MichaelScharf.blogspot.com/

RE: [sqlite] sqlite3_interrupt() and threads

Michael, I notice in the documentation that the sqlite3_progress_handler() method is marked "experimental". Is that significant? Rob

RE: [sqlite] sqlite3_interrupt() and threads

Great! That looks like exactly what I need. Thanks very much! Rob Richardson RAD-CON INC. -Original Message- From: Michael Scharf [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:45 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3_interrupt() and threads Hi

Re: [sqlite] sqlite3_interrupt() and threads

Hi Richard, I use a progres_handler: http://www.sqlite.org/capi3ref.html#sqlite3_progress_handler I set it up to be called every 1 ticks (2nd argument) or so and I use and the void* to points to a data structure that contains a boolean isCanceled. If another thread wants to cancel the worke

RE: [sqlite] sqlite3_interrupt() and threads

Thank you for pointing me to that article. That leads to two more questions: What alternative do I have? If I abort the thread that is running the query, will the query stop? And, if sqlite3_interrupt() has to be issued from the same thread that is using the database, what is it designed to b

Re: [sqlite] sqlite3_interrupt() and threads

Rob Richardson wrote: [...] Can sqlite3_interrupt() be called from a different thread than the sqlite3_step() that I want to interrupt, or is there some other mechanism I can use, or is there no way to do this? This came up a couple of weeks ago. I don't have the message here to quote but you

[sqlite] sqlite3_interrupt() and threads

Greetings! My application will occasionally be called on to execute queries that take several minutes. This will be done from a worker thread so that the user interface remains active. As the query is being executed, the user must be able to respond to alarms. When the user hits F11 to go strai