Sort/select processing when sorting by associated fields
Jay R. Ashworth
jra at baylink.com
Wed Jan 30 13:22:57 PST 2008
On Wed, Jan 30, 2008 at 01:28:30PM -0500, Kenneth Brody wrote:
> Quoting Jay R. Ashworth (Wed, 30 Jan 2008 12:44:01 -0500):
> >On Wed, Jan 30, 2008 at 12:36:50PM -0500, Kenneth Brody wrote:
> >>If you have a file with 100 records, and each record has 5 non-blank
> >>instances of the associated field on which you are sorting, then the
> >>sort/select processing will be run 500 times, not 100. It will be
> >>run for each non-blank instance of the associated field used for the
> >>sort. (This allows you to select only certain instances from within
> >>your sort/select processing.) If all instances of the field are
> >>blank within a given record, the first instance will be selected.
> >
> >That seems like a wart. Why would it run it once?
>
> Because that's the way it was designed. When filePro is dealing with
> associated fields, it only cares about the non-blank instances. But,
> it was also decided that, if all instances were blank, it would still
> use the first instance, and the first instance only.
I would assume that the reason it's doing it is because you *wanted it
to*, yes. :-)
What I was trying to get at was why that decision was taken in the
first place. We're assuming, here, a selection *set* (which supersedes
processing, right? -v only runs against the records that survive -s?)
that includes an associated field. Or perhaps I've had too much to
drink. Already. :-)
Cheers,
-- jra
--
Jay R. Ashworth Baylink jra at baylink.com
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
Those who cast the vote decide nothing.
Those who count the vote decide everything.
-- (Joseph Stalin)
More information about the Filepro-list
mailing list