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.

Reply via email to