Sort/select processing when sorting by associated fields
Kenneth Brody
kenbrody at bestweb.net
Wed Jan 30 10:28:30 PST 2008
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.
--
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