Peter Haworth wrote: > > I have this question too. I'm not programming in C so don;t have > access to the sqlite_last_insert_rowid.... >
Yes you do. You just didn't realize it. Using the cmd line tool: F:\sqlite>sqlite3 SQLite version 3.5.9 Enter ".help" for instructions sqlite> create table a(b); sqlite> insert into a values(17); sqlite> select last_insert_rowid(); 1 sqlite> insert into a values(18); sqlite> insert into a values(19); sqlite> select last_insert_rowid(); 3 sqlite> HTH, and happy turkey day!! Gerry _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
