jt <[EMAIL PROTECTED]> wrote: > Hello, > > Is there a way to force the range value taken by a primary key?
When you insert a NULL into an INTEGER PRIMARY KEY, it always converts the NULL to be one larger than the largest existing value. But you can specify a specific key and skip SQLite's automatic value picker. INSERT INTO table(rowid, ....) VALUES((SELECT rowid+1 FROM table WHERE rowid<429496796), ...); -- D. Richard Hipp <[EMAIL PROTECTED]>