Re: Declare a key on a subfile... is it possible?

Hi everybody!

I was out of the town for a 3 days weekend and now I'm suprised of the
debate my original message started. After I read your answers, I think that
the best solution for me is to declare an array that will have 9999 elements
because it is the limit of a subfile and I just want to fill my subfile
completely before displaying it. I don't want to manage the page up and the
page down events into my program and it is impossible in my case to go up to
9999 records in my subfile anyway.

I know that declaring an array of 9999 is memory consuming but it is not a
big issue for me (I don't think so) because my program will only live about
a week.

I want to thank all the people who answered to my question. Your help is
really appreciated.

END OF DEBATE - Make love, not war ;-)

Charles


<Michael_Schutte@xxxxxxxxxxxx> a écrit dans le
message de
news:OF248DFBBA.A2030C79-ON85257150.00709E60-85257150.00718B3F@xxxxxxxxxxxxxxx
> Scott, you're correct... it's time to relax.
>
> When dealing with small amounts of data, single file reads, etc to fill
> subfile... your solution will work.  However, when dealing with larger
> files, page at a time loads are better.  There's the difference, you
> assumed load at once subfile and I assumed a page at a time.   I was only
> saying that your solution won't work when your dealing with the larger
> amounts of data.
>
> In this case... to clarify my reasoning... maybe a workfile isn't correct.
> However, this subfile is being populated by a physical file somehow... I
> assume.  Meaning the zip code is stored in the file by customer.  So an
> array wouldn't be the best option.  A logical file by customer/zip code
> would be the best option.  Chain by customer/zip code.  if found, then
> don't allow the zip code to be added to the customer.
>
> Yes I know that I said that he should use a workfile and write to it
> whenever there's a write to the subfile.
>
> There's the hole in your logic.  If the data can be reached by a logical
> file, an array isn't needed.   Even though I didn't explain it that way,
> that's what I was getting at.  I would hope that so-called "programmers"
> just need a nudge to find a solution rather than given a full push.
>
> As for the comment about me thinking where subfile records are stored...
> there's an elfenland?
>
> Michael Schutte
> Work 614-492-7419
> email  michael_schutte@xxxxxxxxxxxx
>
>
>
>              Scott Klement
>              <rpg400-l@scottkl
>              ement.com>                                                 To
>              Sent by:                  RPG programming on the AS400 /
>              rpg400-l-bounces@         iSeries
<rpg400-l@xxxxxxxxxxxx>
>              midrange.com                                               cc
>
>                                                                    Subject
>              04/14/2006 04:24          Re: Declare a key on a subfile...
>              PM                        is it possible?
>
>
>              Please respond to
>               RPG programming
>               on the AS400 /
>                   iSeries
>              <rpg400-l@midrang
>                   e.com>
>
>
>
>
>
>
> > I'm sorry if I stepped on your toes Scott, but I was replying to your
> > answer of making the DIM size equal to the SFLPAGE size.
>
> You said it wouldn't work for YOUR situation, Alan.  Maybe that was a
> mistake in your grammar, I don't know.
>
> > YOUR response was WRONG for HIS question and I (as well as others) gave
> > the reason why.
>
> Unfortunately, there were big gaping holes in your reasons.  That's why I
> responded and explained why I wasn't wrong.
>
> a) Charles never said it was a single-page load subfile.
>
> b) Charles' message wouldn't have made any sense for a single page load
> subfile. (Unless I missed it?)
>
> c) My suggestion WOULD work for a single-page load subfile, if small
> enough.  And with modifications, it would work for a larger one as well.
>
> But I've already explained that to you, and you've ignored me.  If you
> want to point out a flaw in my logic, by all means do so.  So far,
> however, you've failed to do that.
>
> It pisses me off when some idiot tells me that solutions I use every day,
> and work very well for me, don't work.  Really, they do.  I use them.  All
> the time.
>
> --
> 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.
>
>