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, and, as long as it is not committed, you could rollback the query if desired. Of course, you would have to design your application accordingly, to provide the interface for the user to "cancel" the query or "approve" it, and only then either rollback or commit, as appropriate. But, you do realize that most queries usually execute within milliseconds. Unless you have some mongo query that takes longer time than most human key-pressing, reaction time, using transactions and rolling them back is probably what you are looking for. > How can I achieve the same? > > Thanks& Regards, > Sachin Gupta > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users