Petite Abeille <petite.abei...@gmail.com> wrote: > On Jan 18, 2012, at 3:35 PM, g...@novadsp.com wrote: > >> "INSERT INTO table (columns) VALUES(?,?,?,?); >> SELECT last_insert_rowid() FROM table;" > > These are really two statements, not one. Execute them one after the other > and you will get the desired effect.
Or just call sqlite3_last_insert_rowid() API function directly, without going through SELECT statement. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
