Amit, On Sat, Apr 27, 2013 at 1:00 AM, Amit Chaudhuri <amit.k.chaudh...@gmail.com>wrote:
> CREATE TABLE playersdrafted(playerid integer, id ineteger, > > Don't think ineteger is what you really mean.....:) > Seen it twice now so guessing it's actually in the code > Why you say so? It is a foreign key representation, so integer is perfectly normal column type. Thank you. > > > On Sat, Apr 27, 2013 at 8:34 AM, Igor Korot <ikoro...@gmail.com> wrote: > > > Simon, > > 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? > > > > Thank you. > > > > > > On Sat, Apr 27, 2013 at 12:10 AM, Simon Slavin <slav...@bigfraud.org> > > wrote: > > > > > > > > On 27 Apr 2013, at 8:05am, Igor Korot <ikoro...@gmail.com> wrote: > > > > > > > No. Using straight insert with values does not work. > > > > Record still not inserted. > > > > > > Okay, so you now don't have to worry about parameters, or a sub-select > or > > > any of those things. What you have identified is that a simple INSERT > > with > > > all values supplied returns SQLITE_OK but doesn't insert a record. > > > > > > Make up a simpler TABLE and try inserting into that one. A table with > > one > > > INTEGER column ? In fact, see if you can get any INSERT command > working > > at > > > all, then work your way up to one that doesn't work and see if you can > > find > > > the thing that makes the INSERT stops working. > > > > > > 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 > > > _______________________________________________ > 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