OK, but I can find out from sqlite3_errcode after the loop if there was an error, saving all the checks inside the loop. Would there be any harm from that?
RBS On Tue, Mar 17, 2015 at 7:52 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 17 Mar 2015, at 7:39pm, Bart Smissaert <bart.smissaert at gmail.com> > wrote: > > > The result is fine and no duplicates are inserted, only thing wrong is > the > > result the one from last sqlite3_finalize. > > Note that I don't check the return values in the loop, maybe I should, > but > > it saves some time. > > The result you get from _finalize() is only guaranteed to tell you about > problems with _finalize(). To find out if _step() worked you have to check > the result from each call to _step(). > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
