RE: subfile?

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

Well that's the reason we went to the page at a time, because we did in
fact have users causing it to blow, even with a Position to field.  That
said that is a good idea Terry.  I will look into that.  

Thanks.

-----Original Message-----
From: Terry@xxxxxxxxxx [mailto:Terry@xxxxxxxxxx] 
Sent: Tuesday, July 01, 2003 2:22 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: subfile?







>I guess I shouldn't have said the Subfile contains more than 9999
>records.  The file does and so I need to be able to handle that.   Well
>anyway, it appears I can't do this with a page at a time subfile and 
>will have to go another route.


Mike,

Don't throw out the baby with the bathwater...

If I were sitting down to write this, I would make SFLSIZ = SFLPAG + 1
(expanding).  Then you can use the SFLFOLD/SFLDROP keywords. Just
because there are over 9999 records in the file doesn't mean that the
subfile ever has to get that large.  I sincerely doubt that a user would
page down over 500 times (@ 20 recs/page) to get at the info they need.
(But I guess it's
possible.)

I would instead give them the ability to position the subfile start
record to any database key they may want, and perhaps provide a filter
so they don't see records they don't want to.

If you think they will ever create a 9999-record subfile by paging, then
test the RRN of the subfile and pop up a window when it's reached
telling them they need to reposition their starting key.

Terry Richardson
Vermont Information Processing, Inc.
terry@xxxxxxxxxx

_______________________________________________
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.