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: [email protected] Subject: 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 10000 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 worker thread it sets the isCanceled to true. The progress callback checks the isCanceled and returns 0 if set. Then the query gets aborted... (I'm using this in java and it works just fine) Michael > 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 be used for? > > OK, three questions: Is there a way to run sqlite3 queries > asynchronously? > > Thanks again! > > Rob Richardson > Rad-Con, Inc. > > -- http://MichaelScharf.blogspot.com/
