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