Thank you Igor! Just to be straight, I would use the Query: SELECT last_insert_rowid() AS TheNewKeyValue FROM TableX
Vance Igor Tandetnik wrote: >"Vance E. Neff" <ven...@intouchmi.com> wrote >in message news:4982fd7c.2090...@intouchmi.com > > >>When I INSERT a new row with INTEGER PRIMARY KEY AUTOINCREMENT >>specified for the key column, how do I find out what the new value >>for that column (the new key value) as that may be the only unique >>column value in the table? >> >> > >http://sqlite.org/lang_corefunc.html >last_insert_rowid > >http://sqlite.org/c3ref/last_insert_rowid.html > >Igor Tandetnik > > > >_______________________________________________ >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
