I believe he specified that was a 10 character field. Which would rule out a leading space. <div><br></div><div>Dan<span></span><br><div><br>On Tuesday, June 24, 2014, Richard Kreiss <<a href="mailto:rkreiss@gccconsulting.net">rkreiss@gccconsulting.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">If you look at the last column there appears to be a leading space except for:<br>
<br>
> T000000153 06/23/2014 0:57:02 JLF james R000000038<br>
> T000068581 06/23/2014 8:51:50 JLF james SC00000204<br>
> T000068581 06/23/2014 8:51:50 JLF james SC00000204<br>
<br>
I would suggest you check this and then delete index D and then rebuild it.<br>
<br>
I have had a running disagreement with Ken on this issue for many years. When one rebuilds an index, it is cleared and then rebuilt.<br>
<br>
When I have had issues with an automatic index, even on rebuild, I have found deleting it and starting over seems to clear up the issue.<br>
<br>
Again, check your field 6 to see if there are leading blanks (right justified values) and if there are, correct this first and then rebuild,<br>
<br>
<br>
Richard Kreiss<br>
GCC Consulting<br>
<br>
Office: 410-653-2813<br>
<br>
<br>
<br>
> -----Original Message-----<br>
> From: filepro-list-bounces+rkreiss=<a href="javascript:;" onclick="_e(event, 'cvml', 'verizon.net@lists.celestial.com')">verizon.net@lists.celestial.com</a><br>
> [mailto:<a href="javascript:;" onclick="_e(event, 'cvml', 'filepro-list-bounces+rkreiss')">filepro-list-bounces+rkreiss</a>=<a href="javascript:;" onclick="_e(event, 'cvml', 'verizon.net@lists.celestial.com')">verizon.net@lists.celestial.com</a>] On<br>
> Behalf Of James Flanagan<br>
> Sent: Monday, June 23, 2014 11:14 AM<br>
> To: filePro Mailing List<br>
> Subject: Issue with Index<br>
><br>
> FreeBSD 9.2<br>
> Filepro 5.7.04<br>
><br>
> Below is a list of automatic Index D, based solely on field 6, a 10 character all<br>
> up field. For some strange reason, the 6th column is not in proper order.<br>
> What is more, the 4th record listed, T000000632, appears twice in the list<br>
> (also the last listed record), but only one record for T000000632 exists in the<br>
> key file. these records are being added to the file using "copy to" command<br>
> between 2 lookups. the same index for the first file works as expected, with<br>
> no issues. somehow, this index keeps getting corrupt.<br>
><br>
><br>
> I N Q U I R E, U P D A T E, A D D 5.7.00.04D4<br>
> ────────────────────────────────────────────────────────────<br>
> ────────────────────<br>
> T000000631 06/17/2014 18:27:46 JLF james R000000013<br>
> T000000501 06/21/2014 17:38:58 JLF james R000000014<br>
> T000000073 06/17/2014 18:28:02 JLF james R000000013<br>
> T000000632 06/21/2014 17:40:40 JLF james SC00000306<br>
> T000000500 06/21/2014 17:40:40 JLF james SC00000306<br>
> T000003517 06/21/2014 18:11:33 JLF james R000000018<br>
> T000003522 06/21/2014 18:11:41 JLF james R000000018<br>
> T000003526 06/21/2014 18:11:50 JLF james R000000018<br>
> T000004000 06/21/2014 18:12:03 JLF james R000000018<br>
> T000004149 06/21/2014 18:20:41 JLF james R000000019<br>
> T000003999 06/21/2014 18:56:40 JLF james R000000022<br>
> T000003998 06/21/2014 18:24:31 JLF james R000000020<br>
> T000003997 06/21/2014 18:26:18 JLF james R000000020<br>
> T000068580 06/21/2014 21:54:58 JLF james R000000030<br>
> T000000153 06/23/2014 0:57:02 JLF james R000000038<br>
> T000068581 06/23/2014 8:51:50 JLF james SC00000204<br>
> T000068581 06/23/2014 8:51:50 JLF james SC00000204<br>
> T000000632 06/21/2014 17:40:40 JLF james SC00000306<br>
> ──Index─────────────────────────────────────────────────────<br>
> ────────────────────<br>
> UP / DOWN -Change Record Enter -Select Record U -Update Record<br>
> S -Set Selection Z -fuZZy Search R -Reset C -Continuous On<br>
> F -Format H -Hardcopy X -Exit<br>
><br>
> When I manually rebuild the index, the index is cleaned up and the phantom,<br>
> out of place, duplicate records disappear.<br>
><br>
> I N Q U I R E, U P D A T E, A D D 5.7.00.04D4<br>
> ────────────────────────────────────────────────────────────<br>
> ────────────────────<br>
> T000000073 06/17/2014 18:28:02 JLF james R000000013<br>
> T000000501 06/21/2014 17:38:58 JLF james R000000014<br>
> T000003517 06/21/2014 18:11:33 JLF james R000000018<br>
> T000003522 06/21/2014 18:11:41 JLF james R000000018<br>
> T000003526 06/21/2014 18:11:50 JLF james R000000018<br>
> T000004000 06/21/2014 18:12:03 JLF james R000000018<br>
> T000004149 06/21/2014 18:20:41 JLF james R000000019<br>
> T000003998 06/21/2014 18:24:31 JLF james R000000020<br>
> T000003997 06/21/2014 18:26:18 JLF james R000000020<br>
> T000003999 06/21/2014 18:56:40 JLF james R000000022<br>
> T000068580 06/21/2014 21:54:58 JLF james R000000030<br>
> T000000153 06/23/2014 0:57:02 JLF james R000000038<br>
> T000000099 06/23/2014 8:46:07 JLF james R000000043<br>
> T000068581 06/23/2014 8:51:50 JLF james SC00000204<br>
> T000000632 06/21/2014 17:40:40 JLF james SC00000306<br>
> T000000500 06/21/2014 17:40:40 JLF james SC00000306<br>
> ***** END OF FILE *****<br>
><br>
> ──Index─────────────────────────────────────────────────────<br>
> ────────────────────<br>
> UP / DOWN -Change Record Enter -Select Record U -Update Record<br>
> S -Set Selection Z -fuZZy Search R -Reset C -Continuous On<br>
> F -Format H -Hardcopy X -Exit<br>
><br>
> This behavior is keeping my lookups for working properly. Thank you in<br>
> advance for your time and attention to this.<br>
><br>
> James Flanagan<br>
> Flantec.com<br>
><br>
> email: James@Flantec.com<br>
> mobile: 760-458-8498<br>
> home: 219-221-6219<br>
> text: <a href="javascript:;" onclick="_e(event, 'cvml', '7604588498@txt.att.net')">7604588498@txt.att.net</a><br>
><br>
> aim: Flantec<br>
> oovoo: Flantec<br>
> Skype: Flantec<br>
> ichat: <a href="javascript:;" onclick="_e(event, 'cvml', 'Flantec@mac.com')">Flantec@mac.com</a><br>
><br>
> home: 1901 Cidermill Road<br>
> Michigan City, IN 46360<br>
><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <a href="http://mailman.celestial.com/pipermail/filepro-" target="_blank">http://mailman.celestial.com/pipermail/filepro-</a><br>
> list/attachments/20140623/84c7d3a2/attachment.html<br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="javascript:;" onclick="_e(event, 'cvml', 'Filepro-list@lists.celestial.com')">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="javascript:;" onclick="_e(event, 'cvml', 'Filepro-list@lists.celestial.com')">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div></div><br><br>-- <br><div dir="ltr">daN baueR<br><a href="mailto:dan@onlinemgt.com" target="_blank">dan@onlinemgt.com</a><br><br></div><br>