|
On Wed, 2004-09-15 at 18:45, Tyler, Matt wrote: > Dan, > Curious, how are you presenting the data set to the user(s), > Page-at-a-time, full-load, other? I have a couple of page-at-a-time SQL > programs that took me a while to figure out the relative cursor positioning > for paging. I use SQL for my subfiles with page-at-a-time. I use "optimize for x rows" based on the subfile size, so subsequent page down requests just do a "fetch next" operation. I have a template you can view here: http://www.rpgnext.com/codesamples/ Look at SFL_TEMP.RPG and SFL_TEMP.DSP. Joel http://www.rpgnext.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
