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/
