Aaron,

I have a lot of different views which return data (say customer list) in a different order and return different subsets.
One view returns customers in a name other.
Second view returns customers by a city order.
Also, there can be large gaps (a large number of records are deleted) in id fields sequence.

The order by primary key is totally different an is not related to those views.

Please explain, how I can use this approach in this case ?


>Dear Andrus,
>
>Then, you may go to harder way. There should have Primary Key in your table, e.g. ID...
>
>For example, ID = 1,2,3....100,....100000
>
>

>nStart = 1  && Starting position
>nRecord = 100 && Display 100 records
>nEnd = nStart + nRecord
>
>SELECT * FROM TABLEA WHERE ID BETWEEN ?nStart TO ?nEnd
>

>
>

>***ON PRESS NEXT PAGE
>nStart = TableA.ID + 1
>nRecord = 100
>nEnd = nStart + nRecord
>
>SELECT * FROM TABLEA WHERE ID BETWEEN ?nStart TO ?nEnd
>

>
>In this way, you can simulate the Offset