Re: [sqlite] select prepared statement always returning SQLITE_DONE

after sqlite3_reset () all bound parameters keep their values they are not unbound or nullified by default so for that purpose you would have to call sqlite3_call_bindings () see link http://www.sqlite.org/c3ref/clear_bindings.html this is not necessary if you want to keep all bound values

Re: [sqlite] select prepared statement always returning SQLITE_DONE

On Thu, 1 Aug 2013 21:22:23 -0700 (PDT), ngsbioinformat...@gmail.com wrote: >Hi all - I've got sqlite embedded in an iOS app. I have a database with 1 >table, and am creating a prepared select statement with a where clause on 1 >field. In my loop, my order of operations is: sqlite3_bind_text,

Re: [sqlite] select prepared statement always returning SQLITE_DONE

On Fri, Aug 2, 2013 at 12:22 AM, wrote: > Hi all - I've got sqlite embedded in an iOS app. I have a database with 1 > table, and am creating a prepared select statement with a where clause on 1 > field. In my loop, my order of operations is: sqlite3_bind_text, >

[sqlite] select prepared statement always returning SQLITE_DONE

Hi all - I've got sqlite embedded in an iOS app. I have a database with 1 table, and am creating a prepared select statement with a where clause on 1 field. In my loop, my order of operations is: sqlite3_bind_text, sqlite3_step, sqlite3_reset. One the first iteration of the loop,