This is exactly what I need. Thanks very much! Mi Chen
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Igor Tandetnik Sent: Tuesday, December 03, 2013 7:46 PM To: [email protected] Subject: Re: [sqlite] sqlite3_interrupt() for controlled interruption On 12/3/2013 9:26 PM, Chen, Mi wrote: > I want to use sqlite3_interrupt() to interrupt the statement that is > executing sqlite3_step() for the first time in the worker. It is mutex > protected so I already make sure that when sqlite3_interrupt() is called, my > worker thread is running sqlite3_step()... > > However, the current sqlite3_interrupt() behavior is to interrupt all the > statements, including the ones that I suspended and running half-ways in the > background. I could make a separate database connection for each query, but > the ability for them to share data (e.g., temp tables) were limited. See if sqlite3_progress_handler helps. A progress handler only cancels one sqlite3_step() call. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
