Petite Abeille <[email protected]> wrote: > On Jan 18, 2012, at 3:35 PM, [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
