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