Re: [sqlite] rowId continuity?

2005-09-14 Thread Jay Sprenkle
Why not use another column? Provide sorted data for your users in some way that provides them with more value. On 9/14/05, R S <[EMAIL PROTECTED]> wrote: > > Hi, > I have a screen which displays rows of my table in a paged form (i.e. one > can do Back/Previous on them and navigate across

[sqlite] rowId continuity?

2005-09-14 Thread R S
Hi, I have a screen which displays rows of my table in a paged form (i.e. one can do Back/Previous on them and navigate across pages). I use the rowId of the top and bottom rows to query for the next/previous set of rows in the page. However I just read somewhere that the rowId need not be