Thanks for that. I Should have searched that :). Now I am Executing the Vacuum query, and sqlite3_interrupt() is called from a different thread, It is interrupted. But once interrupted query execution is failing with SQLITE_ERROR. It has to fail with SQLITE_INTERRUPT right?
sqlite3_errmsg() is returning proper error "[DB: C:\Documents and Settings\All Users.WINDOWS\Application Data/data/sqlitedb.data] interrupted". Am I missing anything here? I am testing with SQLite 3.6.11. Regards, Manohar.S On Thu, Mar 12, 2009 at 4:10 PM, Dan <danielk1...@gmail.com> wrote: > > On Mar 12, 2009, at 4:54 PM, manohar s wrote: > > > Hi, > > Is there any way to interrupt a query which is running? I am > > executing a > > VACUUM query which takes lot of time to complete. I want to stop this > > execution forcefully whenever I want to stop. Is this possible? > > The sqlite3_interrupt() API: > > http://www.sqlite.org/c3ref/interrupt.html > > Dan. > > > > > Regards, > > Manohar > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users