<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Yes, I do use the -i in the menu. I will play around with it some
more. Thanks again.<br>
<br>
Jeff Harrison wrote:
<blockquote cite="mid20060331165614.97419.qmail@web50706.mail.yahoo.com"
type="cite">
<pre wrap="">--- Jaime Perry <a class="moz-txt-link-rfc2396E" href="mailto:jaime@hoovercs.com"><jaime@hoovercs.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap=""><!---->
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
<a class="moz-txt-link-abbreviated" href="mailto:jeffaharrison@yahoo.com">jeffaharrison@yahoo.com</a>
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
<a class="moz-txt-link-freetext" href="http://mail.yahoo.com">http://mail.yahoo.com</a>
</pre>
</blockquote>
</body>
</html>