sort selection table

[daN baueR]

Thanks. I knew there was a disconnect somewhere in the process. That really
clarified the process to me. I'll see if I can skin the cat a different
way.

On Tue, Oct 11, 2016 at 3:19 PM Kenneth Brody <kenbrody at spamcop.net> wrote:

> On 10/11/2016 3:09 PM, daN baueR via Filepro-list wrote:
> > Just wondering if if this environment is too old for this trick. The OS
> is
> > AIX with a old version of filePro 4.5. Or is this just not possible?
> >
> > The report in question was setup in a header file with the body of the
> > report pulling all of the detail lines from another file. This works but
> > the detail lines aren't sorted the way I'd like them to be.
> > The V sort/selection table prompts for a single building code and then
> the
> > report processing uses a loop and a print command to get and all of the
> > data lines.
> > I added a sort command to the -v table but it doesn't affect order of the
> > data lines. The print command can't go in the V table. So is it possible
> to
> > sort the report if all of the data uses dummy variables coded in the
> output
> > form?
> >
> > I know I can recreate the report and base it in the detail file. The
> > problem is It's a larger than normal header and I'm trying not to recode
> > the whole thing.
>
> The SORT command will change the output order of the records being selected
> by the sort/select processing.  However, if the output processing then does
> a LOOKUP/GETNEXT/PRINT loop to print multiple detail items for each main
> record, this has nothing to do with the SORT from sort/select.  The records
> will print in the exact order that you PRINT them.  If you need the detail
> record printed in a different order, then you'll need to PRINT them in a
> different order.  Perhaps create an index in that order, and use that index
> for the LOOKUP?
>
> --
> Kenneth Brody
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20161011/33bc78af/attachment.html>