Re: RPGLE DDS Subfile out of 9999 records limit

I wonder if they have thought of 30,000 divided by 15 records/screen is what? 2,000 up/down clicks from back to front?? Be sure you use a scrollbar!

Having said that, I will add this: Consider using a page at a time and as they select an item toss the selection, as is, into another sub-file and when they press enter, or whatever, process the smaller subfile.

But I'd ask them to at least consider some arbitrary filter that can divide the 30,000 in to 10 or so sub-groups? Life gets a lot easier for them that way. Even if the top of the screen has the alphabet and they click the letter they wish to see next.




J Z wrote:

Hi Alan

Sounds stupid right...?! I know.

It is because the user have no idea which one they want to select/change, so
they insist to have the whole list!


On 9/7/07, Alan Shore <AlanShore@xxxxxxxx> wrote:

Hi J Z
I'm curious as to why you state that you HAVE to load ALL 30,000 records
into the subfile.
Answering this question may present an opening for people to give you
different suggestions



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

rpg400-l-bounces@xxxxxxxxxxxx wrote on 09/07/2007 04:24:44 PM:

Hi,

As you know that IBM restricted to the 9,999 records limit when load a
subfile, and we can just load one page at a time to not limited by the
number of records.

But I have a situation that need to load all data (almost 30, 000

records)

into subfiles, and allow user to do page down, page up to select/change
multiple records. I can do the page down & page up, but how can I get my
selected data 'cause the original SFLRCDNBR can only up to 9999 ?

Any hints, suggestions or sample codes would be really appreciated!

JJ
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.