Announcement

**Mercury** · April 25, 2008, 05:08 AM

Re: sub file type?

Did you really press PageDn key 9999 times ???

**abhishek_ec002** · April 25, 2008, 05:41 AM

Re: sub file type?

if i press more than 9999 times page down button- subfile is dump!

how you came to know that its not working after 9999 times?

once you check the 'number of records' specified in your display file.

**jamief** · April 25, 2008, 06:08 AM

Re: sub file type?

it could be either.........the way to tell is in the DDS.
but since you said you paged down 9999 times cause
you had nothing better to do I can say its a load a page at a time.

otherwise it would have blown up cause the number of records in
PAY01L00 is greater than 9999.

this most likely load all (but not definetly)

Code:

A                                      SFLSIZ(0016)           
A                                      SFLPAG(0014)

This is a page at a time....

Code:

A                                      SFLSIZ(0016)           
A                                      SFLPAG(0016)

That said.........unless you clear the subfile every time and reload
from RRN1 to ?????? on every pageup/pagedown
then either of the two types will blow up at 9999
cause RRN is 4.0 decimal field and being a math genius
if you add 1 to 9999 in a four decimal field then you get 0000
and KAPOW!

**DeadManWalks** · April 25, 2008, 06:16 AM

Re: sub file type?

Also, please note that you can not have a subfile that is larger than 9999. But more importantly, you should not. No user is going to look at 10000 records for the one they want.

**dhanuxp** · April 28, 2008, 04:40 AM

Re: sub file type?

Originally posted by jamief View Post

That said.........unless you clear the subfile every time and reload
from RRN1 to ?????? on every pageup/pagedown
then either of the two types will blow up at 9999
cause RRN is 4.0 decimal field and being a math genius
if you add 1 to 9999 in a four decimal field then you get 0000
and KAPOW!

yes this is the problem?

Code:

A                                      SFLSIZ(0016)           
A                                      SFLPAG(0014)

i create this type of dds for my subfile

thanks
dhanuxp

**dhanuxp** · April 28, 2008, 04:45 AM

Re: sub file type?

Originally posted by DeadManWalks View Post

Also, please note that you can not have a subfile that is larger than 9999. But more importantly, you should not. No user is going to look at 10000 records for the one they want.

so cant we avoid above limitation?

**soup_dog** · April 28, 2008, 07:35 AM

Re: sub file type?

Originally posted by Mercury View Post

Did you really press PageDn key 9999 times ???

LOL. I was wondering the same thing.

**KenM** · April 28, 2008, 08:00 AM

Re: sub file type?

Originally posted by dhanuxp View Post

so cant we avoid above limitation?

9999 is the hard limit on the number of records. If you want your user to be able to scroll through more than 9999 records, you will not be able to use the expanding subfile. You will have to load each page in your programming instead of letting the subfile control it. Depending on your data and use, this can be relatively easy or complex. If the data is a single file read for inquiry only with a simple key, then you just keep track of the key for the first record of each page and keep track of what page you are on and whether the roll up or roll down was pressed.

This can be quite complex when multiple files, filtering and add/update/delete are added, but the core concept is the same, you have to keep track of where in the data you will need to go if the roll down button (page up) is pressed since this is kept track of for you in an expanding subfile, but not in a page by page load.

**kitvb1** · April 28, 2008, 08:45 AM

Re: sub file type?

I know there will be uproar to this reply, but here goes anyway.

To have a SFL with more than 9999 records (as it will appear to the user), i believe the following will work and is not difficult to implement... just requires a little concentration.

1. In your DDS, create more than 1 subfile and related (field names may remain the same)
2. IN your RPG, duplicate and rename all your SFL indicators and counters. eg. SFLRRN becomes SFLRRN1, SFLRRN2, SFLRRN3 etc
3. When SFLRRN1 = 9999, start writing to and displaying the 2nd SFL. Remember to use the correct indicators from now on.
4. On PgUp/PgDn, you have control over which SFL to display anyway, so that shouldn't pose a problem.

Having said all that, I agree with what was previously said in this thread by DMW, dhanuxp and others, i.e. no user is gonna page up & down so many times (although i think we do have one here that would try it just to find out what happens, and then complain about it).

Personally, I try display a max of 1000 recs. If there is a chance that more could be displayed, I built a filter onto the first input screen. when 1000 is reached I display to the user to redefine their selection.

**jamief** · April 28, 2008, 08:50 AM

Re: sub file type?

I mentioned the method to make this work....

unless you clear the subfile every time and reload
from RRN1 to ?????? on every pageup/pagedown

this does add a BUNCH of overhead to your program...
if you clear your subfile and reload each time then you must save
any previous selection(s) (an array maybe)
IMHO .... this extra work is not required.

jamie

**FaStOnE** · April 28, 2008, 09:45 AM

Re: sub file type?

Why not do an "info" check (Select Count(*) from) before you start loading and tell the user they're retrieving more than 10,000 records and to please refine their search? Or, put a hard limit on it to say 5,000 records if you have to. I agree with the sentiment that more than 1k - 3k records is enough for anyone to scroll through, especially at 15 records per page.

**kitvb1** · April 28, 2008, 09:58 AM

Re: sub file type?

Actually, it's the Google-ization of mankind...

Who looks at anything beyond the first 3 pages? If it's not found by then, one loses interest and redefines the search anyway.

To quote Jamie

(that attention span thing caused by fast food & the internet )

http://www.code400.com/forum/showpos...3&postcount=13

**dhanuxp** · April 28, 2008, 09:44 PM

Re: sub file type?

Originally posted by Mercury View Post

Did you really press PageDn key 9999 times ???

hi

for what??? i initialize 9996, and press 4 time pagdn!

dhanuxp

**dhanuxp** · April 28, 2008, 09:48 PM

Re: sub file type?

Originally posted by kitvb1 View Post

1. In your DDS, create more than 1 subfile and related (field names may remain the same)
2. IN your RPG, duplicate and rename all your SFL indicators and counters. eg. SFLRRN becomes SFLRRN1, SFLRRN2, SFLRRN3 etc
3. When SFLRRN1 = 9999, start writing to and displaying the 2nd SFL. Remember to use the correct indicators from now on.
4. On PgUp/PgDn, you have control over which SFL to display anyway, so that shouldn't pose a problem.

bit hard kit, but hope to try it

thanks
dhanuxp

Announcement

sub file type?

sub file type?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment