Simon, On Fri, Apr 26, 2013 at 7:48 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 27 Apr 2013, at 3:29am, Igor Korot <ikoro...@gmail.com> wrote: > > > sqlite> SELECT ownerid FROM owners WHERE ownername = 'Team 1' AND id = 1; > > 53 > > For testing, kill the sub-select in your INSERT command and just put a 53 > in there. See if that changes anything. > Nope. Record is still not inserted. > > > sqlite> > > Please retrieve the values returned by > > last_insert_rowid() > > or the C function > > sqlite3_last_insert_rowid(sqlite3*) > > before and after the insert and see if the insert changes the value. > After doing that ... > This insert is inside transaction. It is first query in it and it's only an insert. There are about 300 updates as well. So at which point I need to retrieve the last inserted id: right after insert or when transaction finishes? > > Please substitute your INSERT command with the simplest possible INSERT > command you can think of and see if that has the desired effect. First try > one which inserts fixed values. If that works properly ... > No. Using straight insert with values does not work. Record still not inserted. Thank you. > > Try putting the sub-SELECT back in. Then try putting in one of the > parameters. Then add more parameters. See if you can spot the point at > which the command 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