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

Reply via email to