Re: Looking for Skeleton RPG program

[Paul Bailey <PabloMotte+Midrange@xxxxxxxxx>]

Hi,

I think you are looking for an example of a paging subfile that only loads
a small number of records at a time and then the user has to page up/down
to load previous/subsequent records.

Look at <http://martinvt.com/Subfiles/Paging_SFL/paging_sfl.html> by Booth
Martin (a regular on this list). The important bits in the example are
manually dealing with the pageup/down and setting the SFLPAG and SFLSIZ
equal in the DDS.

If you have thousands of records that might need to be paged through then
you'll have to combine this example with additional tricks to allow the
user to position to some known data or row (unless you like frustrated
users), and I'd suggest that using embedded SQL and a read-only SCROLL
CURSOR are the best ways to load the data for the subfile instead of
SETLL/READ native file operations. Look at <
https://www.itjungle.com/2015/06/02/fhg060215-story01/> for paging with SQL
cursors by Paul Tuohy.

We're switching to using JavaScript/HTML/etc. to display all data instead
of RPG/DDS, and all this mess with "subfiles" is so much easier (and
prettier). If you get the chance, go that way instead.

Good luck!


-Paul.



On 8 January 2018 at 09:21, p.Caroti <p.caroti@xxxxxxxx> wrote:

> Hi Bruno
>
>
>
> I'm looking for a "solid" skeleton from which start that manage also the
> condition to display a database file (in a subfile) that a have more than
> 9999 rows
>
>
>
> Thanks in advance
>
>
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD