Sort/select processing when sorting by associated fields
Kenneth Brody
kenbrody at bestweb.net
Wed Jan 30 12:15:25 PST 2008
Quoting Boaz Bezborodko (Wed, 30 Jan 2008 12:55:36 -0500):
>
>> Date: Wed, 30 Jan 2008 12:36:50 -0500
>> From: Kenneth Brody <kenbrody at bestweb.net>
[...]
>> You can verify this by creating a simple file. For ease of setting
>> this up, create a file with five instances of A1, and add 5 records
>> filling in only 3 instances for each record. Then, create an output
>> sorted on A1. Finally, create a sort/select processing:
>>
>> mesgbox "Record " < @rn { "\n at AF = " < @af { "\nA1 = " & A1
>>
>> When you run the output, you will see that your processing is run
>> 15 times -- one time for each non-blank instance of A1.
>>
> How does doing the Sort/Selection process on an indexed NON-associated
> field affect this? I'm asking since my approach is obviously messing
> things up some since it only ever goes through the first record once
> despite how many associated fields there are.
Take my example, add an additional non-associated field. Build an
index on this field, and run your output with the appropriate "-i"
flag.
> BTW, I found a workaround that I am satisfied with for now. Instead of
> jumping to the first instance in the index of records I want to choose,
> I pick a spot a little before it. So if 'ba' holds the start date of
> the selection set based on index 'O', the line looks like this.
Unless, of course, you are looking for the very first date in the file.
[...]
--
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