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" <[email protected]> wrote >in message news:[email protected] > > >>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 >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
