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