On Mar 13, 2009, at 5:41 PM, manohar s wrote: > 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?
Which function returns SQLITE_ERROR? What does sqlite3_errcode() return? Dan. > > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
