<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">thanks to everyone. the issue turned out not to be with the index, but with the convoluted way i was looking up the index to find the records i needed, then performing a duplicate lookup to the same index (with different label), and then modifying that record in the 2nd lookup in the indexed field and then attempting to get next on the next record in the first lookup. needless to say, it was a huge mess that somehow made sense in my mind, for at least a short time. thanks again.<br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); "><br class="Apple-interchange-newline">James Flanagan</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="text-decoration: underline; "><a href="http://Flantec.com/">Flantec.com</a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); min-height: 14px; "><br></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">email:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:James@Flantec.com"><span style="text-decoration: underline; color: rgb(0, 106, 227); ">James@Flantec.com</span></a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">mobile:<span class="Apple-tab-span" style="white-space: pre; "> </span>760-458-8498</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">home:<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>219-221-6219</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">text:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:7604588498@txt.att.net"><span style="text-decoration: underline; color: rgb(0, 106, 227); ">7604588498@txt.att.net</span></a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); min-height: 14px; "><br></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">aim:<span class="Apple-tab-span" style="white-space: pre; "> </span>Flantec</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">oovoo:<span class="Apple-tab-span" style="white-space: pre; "> </span>Flantec</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">Skype:<span class="Apple-tab-span" style="white-space: pre; "> </span>Flantec</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">ichat:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:Flantec@mac.com"><span style="text-decoration: underline; color: rgb(0, 106, 227); ">Flantec@mac.com</span></a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); min-height: 14px; "><br></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">home:<span class="Apple-tab-span" style="white-space: pre; "> </span>1901 Cidermill Road</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); "><span class="Apple-tab-span" style="white-space: pre; "> </span>Michigan City, IN 46360</div></span>
</div>
<br><div><div>On Jun 24, 2014, at 2:32 PM, Kenneth Brody <<a href="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">On 6/23/2014 11:14 AM, James Flanagan wrote:<br><blockquote type="cite">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<br>character all up field. For some strange reason, the 6th column is not in<br>proper order. What is more, the 4th record listed, T000000632, appears twice<br>in the list (also the last listed record), but only one record for<br>T000000632 exists in the key file. these records are being added to the file<br>using "copy to" command between 2 lookups. the same index for the first file<br>works as expected, with 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> 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></blockquote>[...]<br><blockquote type="cite"> 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></blockquote>[...]<br><blockquote type="cite">When I manually rebuild the index, the index is cleaned up and the phantom,<br>out of place, duplicate records disappear.<br></blockquote>[...]<br><br>You don't have enough information to make a definite diagnosis, but I would<span class="Apple-converted-space"> </span><br>start looking at the lookups themselves, and verifying that you are<span class="Apple-converted-space"> </span><br>protecting the ones you modify.<br><br>You might want to try PFCHECKLOCK=ON as a start.<br><br>--<span class="Apple-converted-space"> </span><br>Kenneth Brody<br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto: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">http://mailman.celestial.com/mailman/listinfo/filepro-list</a></div></blockquote></div><br></body></html>