Sort/select processing when sorting by associated fields

Jay R. Ashworth jra at baylink.com
Wed Jan 30 09:44:01 PST 2008


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?

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