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