From: jhnlmn <jhn...@yahoo.com> To: sqlite-users@sqlite.org Sent: Friday, June 21, 2013 3:20 PM Subject: Re: [sqlite] How to interrupt a long running update without roll back?
Alas, none of the above answered my original question "How to interrupt a long running update without roll back". But, guess, I will not get an answer. I don't know if it'll work for your application (there being a cost), but a before trigger that performs an raise(ignore) seems to interrupt an update without a rollback. So a trigger of the form: create trigger inter_update before update on my_table begin select raise(ignore) where my_function() = 1; end; Seems like it should interrupt an update when you take some action to make my_function() return 1 without causing a rollback, according to my quick test. Peter _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
