Can I do the select last_insert_rowid();
to determine the new index value After the COMMIT command? Vance Igor Tandetnik wrote: >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 > > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
