Apologies for noise. That was an error on my side, which was discovered after spending couple of hours debugging.
Thank you all for the help and sorry once again. On Sat, Apr 27, 2013 at 5:20 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 27 Apr 2013, at 8:34am, Igor Korot <ikoro...@gmail.com> wrote: > > > In the other area of the program I have a transaction that does 5 or 6 > > inserts and no selects. > > This transaction works fine as I just verified. > > > > Now in the failing case the flow goes like this: > > > > First the program updates couple of tables, then it inserts this > particular > > record. > > This algorithm is going thru the loop of the players vector. > > I'm using the same handle and the same statement object. Only different > > queries. > > > > After every query I'm calling sqlite3_finalize() to free the memory and > the > > statement object. > > > > Am I doing it wrong? > > See section 3.0 in > > <http://www.sqlite.org/cintro.html> > > If you're not sure whether you're doing it right or not, stop doing it. > Do a _prepare() _step() _finalize() on each command and see if that fixes > your problem. Once you know what fixes it you'll know what to do in your > final code. > > You are not doing sufficient exploration yourself to tell us what's wrong. > You are combining both a complicated INSERT and a complicated SELECT and > we have no way to tell which one isn't doing what you expected. > > Create a new table with just one integer column. Write code in your > language to > > Count the rows in your table. > Insert a new row in that. > Count the rows again. > > Do it first with _exec instead of _prepare() _step() _finalize(). If your > code doesn't work you now have something incredibly simple to debug. If it > does work, gradually add the complications of your original example back in > until it stops working. At that point you will have identified what it is > you're doing that isn't working properly. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
