On 4/19/16, Nikolaos Tsikoudis <tsikudis at brandeis.edu> wrote: > Hi, > > I'm wondering if there is a way to stop the query I execute in a SQL > Function, the one you create by using the sqlite3_create_function > functions.I > have created a SQL function which is called for every tuple returned by my > queries and I would like the query to stop when a statement in the function > is satisfied, even if there are more tuple to be returned by the query. >
https://www.sqlite.org/c3ref/interrupt.html Or have your function throw an error using sqlite3_result_error() - https://www.sqlite.org/c3ref/result_blob.html -- D. Richard Hipp drh at sqlite.org
