Re: SQL Position-To with scroll-backwards capability

'k.  Thanks for confirming what I suspected.  Will work with
subsetting and scrolling through that vs. Position To.

- Dan

On 7/29/05, Wilt, Charles <CWilt@xxxxxxxxxxxx> wrote:
> Ok, that's a little different.
> 
> So your criteria is "where FIRSTNAME like 'Dan%'"
> 
> Your results set would be
> Dan
> Daniel
> <....>
> Dann
> 
> 
> >From the first page, you want to be able to do a position to: Dann
> 
> Then, be able to page up from there?
> 
> 
> Can't be done.
> 
> First, you can't do the position to without closing the cursor and opening an 
> new one, "where FIRSTNAME >= 'Dann'".
> 
> Once you open the cursor, you can't page backup past the first record 
> returned. Like I said in my original post, you could fake this out by opening 
> a new cursor, "where FIRSTNAME <= 'Dann' order by FIRSTNAME DESC"
> 
> 
> The only possible way to do what you want to do would be to move the original 
> 10,000 record result set into a temporary storage area, either a table or 
> user space.  This way, you could page back and forth and do whatever 
> searching you need.
> 
> I wouldn't move all 10,000 at the beginning.  Just move them as you need to.
> 
> 
> 
> Again, subsetting instead of positioning is a better alternative when using 
> SQL.
> 
> 
> HTH,
> 
> Charles Wilt