Baruch Burstein <bmburst...@gmail.com> wrote: > Is there an easier way to get a single value (for instance "select > last_insert_rowid();" ) then prepare -> step -> column -> finalize?
For this specific example, there's sqlite3_last_insert_rowid API function. In general, no, there's no special way to handle SELECT statements that return a singleton (one row/one column) resultset. You can always write your own helper function, of course. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users