Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote:
How do I cancel a long running query?
There are two ways I know of. You can register a progress handler - see sqlite3_progress_handler. The handler is called periodically while the query is running, and has the option to interrupt the query.
Another way is to use sqlite3_interrupt. Before SQLite 3.3.7 (which I believe is the latest version at this time), sqlite3_interrupt could only be called from the same thread that created the connection, which as far as I can tell renders the function completely useless. With SQLite 3.3.7 it can be called from a different thread. So make sure to download the latest version.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
