RE: Supporting Previous Page / Next Page in SQL?

I believe what you are looking for is a cursor. The SQL Programming with Host 
Languages book will give you all the gory details for the language of your 
choice, as long as it's one they included.

> -----Original Message-----
> From: Nathan M. Andelin [mailto:nandelin@RELATIONAL-DATA.COM]
> Sent: Thursday, January 23, 2003 12:45 PM
> To: midrange-l@midrange.com
> Subject: Supporting Previous Page / Next Page in SQL?
> 
> 
> When using SQL for database access, how does one support 
> "Previous Page" and
> "Next Page" user interface controls while browsing a lengthy list of
> records?  Building some type of record level access logic 
> over the top of
> SQL?  If so, how are multiple users supported over the 
> Internet?  Having a
> separate result-set object for each user?
> 
> Thanks,
> 
> Nathan M. Andelin
> www.relational-data.com
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>