RE: subfile?

[Terry@xxxxxxxxxx]

>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