Vance E. Neff <ven...@intouchmi.com> wrote: > Just to be straight, I would use the Query: > SELECT last_insert_rowid() AS TheNewKeyValue FROM TableX
No, you would just do select last_insert_rowid(); Or you could call sqlite3_last_insert_rowid() API directly. Last inserted ROWID is the property of a connection, not of a table. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
