Re: How to find the n-th record ?
The idea is to obtain a query with all lines numbered. so, in that moment you can access any record you want writing where Number=2000
Steps:
1. a functions that receives n and returns n=n+1
2. obtain a data set with order number:
select function(n) as Number, field1,field2 from MyTable order by.... what you want
3. select x.Field1,x.field2 from (select function(n) as Number, field1,field2 from MyTable order by.... what you want ) as x where x.Number=5000.
Hope it helped
Daniela
******
I would love to change the world, but they won't give me the source code