sinisa@stripped (sinisa@stripped) writes:
> Joseph R. Junkin writes:
> > Is there any way to grab the 'Previous' or 'Next' record from a
> > previously select record without having to iterate through the whole
> > set? I am using DBI and I need this to work with dynamic (sorted or
> > grouped) sets.
> > Any ideas?
> > Thanks,
> > Joe Junkin
> > jjunkin@stripped
> Cursors are on a TODO list with a high priority !
He could also use MyC, which supports MoveNext and Move Previous, if he were
writing in C. MyC fetches the entire result set, so you can do stuff like this.
Doesn't the Perl DBI module let you do something similar?