RE: Subfile page at a time question.

Thanks for all who helped. There was a problem w/ the file key. It
wasn't unique enough for a page at time, while for load all, it wasn't
an issue.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Dow (ML)
Sent: Wednesday, August 23, 2006 4:54 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Subfile page at a time question.

Hi Phil,

Keep in mind where the file cursor is.  After you've read records 
100-109 for example, the next record read (forward) will be 110.  If you

want to load the previous 10 records, you have to read back to rrn 90.  
In other words, read previous for twice the number of records in your 
subfile page.  It appears you're only reading back 1 page worth.

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

Phil Kestenbaum wrote:

HI,

 

I have to 'convert' a load all subile, to a page at a time. I noticed
that the amount of data the application could generate, could easily
surpass the 9999 limite.

 

I have some code that I will call when the Rollupdn key is pressed:

 

0381.00 C     savkey        setll     oepwrkri


0382.00  *


0386.00 C                   do        sflpag_plus_1


0387.00 C                   readp     oepwrk


0388.00 C                   if        %eof


0389.00 C     *loval        setll     oepwrk


0390.00 C                   leave


0391.00 C                   endif


0392.00 C                   enddo              

 

After this, the Clear Sfl and Bld Sfl is run. The Savkey is created

when

RRN is = 1 and is done after the Write to the Subfile

 

What is happening that pages are loading fine. When scrolling back
however it is only going back one page and then is halted there. I

tried

to debug but didn't see anything, I think I am missing an obvious
fundamental. 

 

Any thoughts/ideas would be a great help.

 

Phil

                            


This message contains information proprietary to our company. It is

intended to be read only by the individual or entity named above or
their designee.

Any distribution of this message or the information contained herein

without written permission from our company is strictly prohibited. If
the reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately by e-mail, and delete the original message.