SQLite Forum

Cancelling the query
Hi, ALL,

There is sqlite3_interrupt() which should cancel the currently running operation.
However I have questions about it:

1. Lets say I have a thread that shuold continuously running and query the DB for a new tables. And at some point of time I will run the SELECT statement with _prepare/_step/_finalize again in a thread. Now when I call sqlite3_interrupt - which operation will be cancelled?

2. What will happen with the statement handle after this call? Should there be a _finalize call?

3. Is there another SQLite API that will allow to cancel the running statement (see question 1)?

Thank you.