sqlite3_errcode() was not used, I was just checking the return code of sqlite3_step(), I read about the problem with sqlite3_step(), I will think about using sqlite3_prepare_v2().
It is returning with SQLITE_INTERRUPT if I use sqlite3_errcode(). Thanks for replying, Manohar On Fri, Mar 13, 2009 at 4:35 PM, Dan <danielk1...@gmail.com> wrote: > > 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 > -- hope is the only thing which keeps us all happy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
