Re: Subfile > 9999 records

Mark Allen <allenmar@xxxxxxxxx>wrote:

> OK, drawing a BIG blank on this one, I have a subfile where
> SFLSIZ=PAGSIZ+1, with the typical 4.0 RRN (SFLRCDNBR) defined
> as a hidden field.  I am having a problem once the user scrolls
> past the 9999th record in the file being displayed with receiver
> too small (using eval statement)....

You're up against a hard limit with 9,999 records in the subfile and will
have to come up with a work-around. Here are some possibilities:

1.  Disable pagedown and set SFLEND on once the 9,999th record has been
written. You could also display a message to the user advising them to use
the "position to" feature you (obviously will) have provided and continue
hammering the poor iSeries from there.

2. As you approach some arbitrary limit which is less than 9,999 simply
clear the subfile and load the next page as though it were the first. If
the user pages up again past your new start of subfile you clear the
subfile again and rebuild it starting with the previous page. If there is
an options field you will have to store, reload and execute these options
somehow, possibly using a user index. Alternatively you just disable pageup
and tell the user he or she is out of luck.

3. Make it a single page subfile SFLSIZ=PAGSIZ+1 and handle all the
scrolling within the program including storing, reloading and executing
options. Then you have no limits.

4. Obtain one of these <http://tinyurl.com/dg28u> and beat your user about
the head with it every time he or she loads 9,999 records into a subfile.

--
Dave...


______________________________________________________________________
This message may contain confidential information which may also be legally 
privileged and is intended only for the use of the parties to whom it is 
addressed. If you are not an intended recipient you are hereby notified that 
any disclosure, copying, distribution or use of any information in this e-mail 
is strictly prohibited. If you receive this message in error please notify the 
sender by return e-mail and then destroy it. Further, we make every endeavour 
to keep our network free from viruses. However, you do need to verify that this 
e-mail and any attachments are free of viruses as we can take no responsibility 
for any computer viruses which might be transferred by way of this e-mail. All 
information and attachments remain the property of Stolt Offshore Group and 
should be held as confidential.