Re: [sqlite] Autoincrement Reset?

In message <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > Adam <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have a table which includes a column "customorder integer primary key > > autoincrement" which I use to address rows in the table. > > > > When I delete a row, I renumber the remaining ro

Re: [sqlite] Autoincrement Reset?

Adam <[EMAIL PROTECTED]> wrote: > Hi, > > I have a table which includes a column "customorder integer primary key > autoincrement" which I use to address rows in the table. > > When I delete a row, I renumber the remaining rows so that the key remains > continuous (to match my GUI display). Howev

[sqlite] Autoincrement Reset?

Hi, I have a table which includes a column "customorder integer primary key autoincrement" which I use to address rows in the table. When I delete a row, I renumber the remaining rows so that the key remains continuous (to match my GUI display). However, when I subsequently insert a new row, the