On 22 Aug 2011, at 8:43pm, Black, Michael (IS) wrote: > I thought we were answering the question "how can I retrive the last row" -- > though we never got a definition of what "last" meant. [snip]
which is, of course, the problem with that question. > Don't you agree that using autoincrement properly guarantees retrieving the > last inserted row? As long as you're not messing about with the way SQLite does things, using the SELECT ... ORDER BY rowid DESC LIMIT 1 form is as good an answer as any. By the way, I don't think anyone has mentioned either SELECT last_insert_rowid() FROM myTable or the sqlite3_int64 sqlite3_last_insert_rowid(sqlite3*) C function yet. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
