Re: Sort file by computed field
From: Warren Simmons (wsimmons5_at_optonline.net)
Date: 06/14/04
- Previous message: Clark F. Morris, Jr.: "Re: Is it possible to use the value of the PROGRAM ID within the source code?"
- In reply to: Sally Pascoe: "Sort file by computed field"
- Next in thread: Howard Brazee: "Re: Sort file by computed field"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 14 Jun 2004 00:59:42 GMT
Sally,
You say that you are to sort on a computed field that is not in the
record.
One guess would be, do the computation, and add the value of that
result to a field you place in the interium file (first pass of the
sort).
Then it seems that it would be possable to sort the records on that
added field, and create what ever resulting record layout you need
for the output in the Last pass own code. As it stands it looks like
you are grouping something by value.
All the 100, 200, 300, etc. BTW, I mean the first record with no value
would appear as the first record of the output file along with all the
other records with no value. If that group has a name, it might be
something like all between one value and the next group minus one.
\
You will probably get other opinions.
Warren Simmons
Sally Pascoe wrote:
> I want to sort records for a report in descending order of a computed
> field.
>
> How do I sort records in a file based on a computed field based on two
> fields in that file but the computed field is not in the file?
>
> Even a keyword for the command so I had something to look for would be
> a help.
>
> Thank you
- Previous message: Clark F. Morris, Jr.: "Re: Is it possible to use the value of the PROGRAM ID within the source code?"
- In reply to: Sally Pascoe: "Sort file by computed field"
- Next in thread: Howard Brazee: "Re: Sort file by computed field"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
