Sort/select processing when sorting by associated fields
Kenneth Brody
kenbrody at bestweb.net
Wed Jan 30 13:34:16 PST 2008
Quoting Jay R. Ashworth (Wed, 30 Jan 2008 16:22:57 -0500):
> 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. :-)
Yes, the sort/select processing only gets records that make it through
any selection set.
Also, remember that, if the record has all instances of the associated
field blank, and blank does not pass the selection set, the record won't
be selected.
--
KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com
More information about the Filepro-list
mailing list