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
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
