On Fri, Oct 14, 2011 at 1:44 AM, Petite Abeille <[email protected]>wrote:
> > On Oct 14, 2011, at 10:23 AM, James Hartley wrote: > > > Is > > there a way to save the value of last_insert_rowid() as a SQL statement? > > Sure. > > insert > into my_very_own_last_insert_rowid > ( > my_last_insert_rowid > ) > values ( > last_insert_rowid() > ) > Thanks. I was making it too hard ... > > Lastly, shouldn't the last INSERT statement below fail given that a row > in > > the parent table doesn't exist with a parent_id = 2? > > > Sure. > > PRAGMA foreign_keys = ON > Ah, I forgot that I only set this pragma on in the first session. Thank you for your corrections. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
