Associated fields question

[Jeff Harrison]

--- Jaime Perry <jaime at hoovercs.com> wrote:

> 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
> 
> 

You mentioned that you rebuilt your index, but you did
not say how you were using the index.  If you are just
running a report and sorting it, that does not use the
index, so I assume you mean that you used the -i flag
for dreport?

I also got too many records when I used the -i flag
with the associated field index in conjunction with -v
processing that used the select command, when the
output format included the associated field in its
sort.

It seems to work properly if you remove the sorting on
the output format itself when you will be using an
input index with dreport.  

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and imports.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com