Dixon Hutchinson wrote:
[...] I was hoping to get the behavior specified at
http://www.sqlite.org/autoinc.html. where the AUTOINCREMENT keyword is
not used.
but you are getting quite exactly what is stated there:
«If you ever delete rows or if you ever create a row with the maximum
possible ROWID, then ROWIDs from previously deleted rows might be reused
[...]»
with AUTOINCREMENT you would get:
«The ROWID chosen for the new row is one larger than the largest ROWID
that has ever before existed in that same table»
where 'larger than' implies 'different from'...
which behaviour do you actually need?
ciao,
Mario
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
