Re: [sqlite] Query optimization: Checking for existence before performing action

On Mon, 29 Jul 2013 13:23:07 +0100 Simon Slavin wrote: > INSERT OR IGNORE a new row with the correct 'word' and a confidence > of 0 > UPDATE the row with that word to increment the confidence. ... > If that solution doesn't work for you you might like to try first > doing

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