Associated fields question

Jaime Perry jaime at hoovercs.com
Fri Mar 31 06:55:13 PST 2006


Ok, I think I get it now, BUT.....

I commented out the  sort1=un; sort2=jobs[@af]&un; sort3=2 line and set 
the first sort in the output processing to J1).  That is now the only 
sort defined.  However, when I run the report using the same selection I 
attached earlier (minus the above line), my test record shows up 4 times 
(using debugger for employee 123) instead of the 2 times I would 
expect.  The test record is below:

  EMPLOYEE#: 123

  DEPT     JOB NO.   COMP    COST CODE    RATE    TYPE       HOURS      
EXTENSION
  352D10¦  352000¦    DE658¦      5200¦ 000¦         28.71¦     R¦      
       8.00¦           229.68¦
  387D10¦  387000¦    DE658¦      5200¦ 000¦         28.71¦     
R¦             8.00¦           229.68¦

As you can see, there are 2 instances of job number for this record.  I 
would therefore expect to hit this record twice not four times using my 
index on job number (J1).  Any thoughts on what would cause this?  I 
rebuilt the index... no difference.  I deleted and rebuilt the index 
with no difference.  @af show instance 1 then 2 for the first 2 times 
and then 1 and 2 again for the third and fourth times I hit the record.  
I should be selecting 196 "records".  Since I made the above change, the 
process now selects 205 so I think this is happening on a couple other 
records but not all.  The process also seems to take a couple seconds 
longer than it did before.

Jaime Perry



Kenneth Brody wrote:
> Quoting Jaime Perry (Thu, 30 Mar 2006 15:16:11 -0500):
>
>   
>> I am still not sure what you mean by using just the first field.  I am
>> obviously missing something and I think you may be on the right track
>> but I am just missing what you mean.  I appreciate everyones help by the
>> way.
>>
>> Let me give you as much info as I can:
>>     
> [...]
> ::sort1=un; sort2=jobs[@af]&un; sort3=2:
> [...]
>
> Here you have told filePro not to sort on an associated field.
>
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060331/d95aa076/attachment.html


More information about the Filepro-list mailing list