Re: [sqlite] sqlite3_interrupt() and threads

2006-07-26 Thread Jens Miltner
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

2006-07-25 Thread Shi, Chunde CTR DISA PEO-C2C
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

2006-07-25 Thread drh
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

2006-07-25 Thread Michael Scharf
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

2006-07-25 Thread Rob Richardson
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

2006-07-25 Thread Rob Richardson
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

2006-07-25 Thread Michael Scharf
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

2006-07-25 Thread Rob Richardson
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

2006-07-25 Thread Martin Jenkins
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