Re: [sqlite] Cancel execution of a executing Query

2010-12-28 Thread Simon Slavin
On 29 Dec 2010, at 5:17am, Sachin Gupta wrote: > I thought so too. But the application that we are working on is kind of > heavily multi-threaded and needs to be thread safe. SQLite is itself thread safe, as long as you don't use the PRAGMAs to defeat all the safety precautions. It might be w

Re: [sqlite] Cancel execution of a executing Query

2010-12-28 Thread Sachin Gupta
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Puneet Kishor Sent: Wednesday, December 29, 2010 10:40 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Cancel execution of a executing Query Sachin Gupta wrote: > Hi, > > Suppose that there is a query exe

Re: [sqlite] Cancel execution of a executing Query

2010-12-28 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/28/2010 09:05 PM, Sachin Gupta wrote: > Suppose that there is a query executing on the in memory Database which I > have executed. Now in my application, I want the user to have the > functionality to be able to cancel the ongoing query dependi

Re: [sqlite] Cancel execution of a executing Query

2010-12-28 Thread Puneet Kishor
Sachin Gupta wrote: > Hi, > > Suppose that there is a query executing on the in memory Database which I > have executed. Now in my application, I want the user to have the > functionality to be able to cancel the ongoing query depending on certain > scenarios. > You could use transactions, an