On 9 Dec 2015, at 8:35pm, Wade, William <bill.wade at dnvgl.com> wrote:
> https://www.sqlite.org/autoinc.html says (for the no AUTOINCREMENT case, > which applies to the original post) "If no ROWID is specified on the insert > ... [the] usual algorithm is to give the newly created row a ROWID that is > one larger than the largest ROWID in the table prior to the insert." As well as the exceptions you've noted don't forget to take into account the possibility that a row may be deleted after others have been inserted after it. Simon.