Associated fields question

Jaime Perry jaime at hoovercs.com
Fri Mar 31 10:49:37 PST 2006


Yes, I do use the -i in the menu.  I will play around with it some 
more.  Thanks again.

Jeff Harrison wrote:
> --- 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 
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060331/bc9ccb3d/attachment.html


More information about the Filepro-list mailing list