On Mon, 17 Jan 2005, Michael Knigge wrote: >All, > >how do I close a cursor with SQLite --> I want to stop processing a >SELECT before sqlite3_step() returns SQLITE_DONE... > >Is sqlite3_interrupt() the right way? Does sqlite3_interrupt() deletes >the prepared SQL-Statement?
sqlite3_interrupt() is not the right way, and does not delete the prepared statement. It is for use in signal handlers, for example, to abort a long running statement. Use sqlite3_finalize(). See: http://www.sqlite.org/capi3ref.html#sqlite3_finalize Note the paragraph about finalizing a prepared statement before it is finished. > >Thank you, > Michael > -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \