Issue with Index

[James Flanagan]

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.

James Flanagan
Flantec.com

email:	James at Flantec.com
mobile:	760-458-8498
home: 	219-221-6219
text:		7604588498 at txt.att.net

aim:		Flantec
oovoo:	Flantec
Skype:	Flantec
ichat:	Flantec at mac.com

home:	1901 Cidermill Road
		Michigan City, IN 46360

On Jun 24, 2014, at 2:32 PM, Kenneth Brody <kenbrody at spamcop.net> wrote:

> On 6/23/2014 11:14 AM, James Flanagan wrote:
>> FreeBSD 9.2
>> Filepro 5.7.04
>> 
>> Below is a list of automatic Index D, based solely on field 6, a 10
>> character all up field. For some strange reason, the 6th column is not in
>> proper order. What is more, the 4th record listed, T000000632, appears twice
>> in the list (also the last listed record), but only one record for
>> T000000632 exists in the key file. these records are being added to the file
>> using "copy to" command between 2 lookups. the same index for the first file
>> works as expected, with no issues. somehow, this index keeps getting corrupt.
>> 
>> 
>>                      I N Q U I R E,  U P D A T E,  A D D            5.7.00.04D4
>> ────────────────────────────────────────────────────────────────────────────────
>>    T000000631 06/17/2014 18:27:46 JLF james      R000000013
>>    T000000501 06/21/2014 17:38:58 JLF james      R000000014
>>    T000000073 06/17/2014 18:28:02 JLF james      R000000013
>>    T000000632 06/21/2014 17:40:40 JLF james      SC00000306
>>    T000000500 06/21/2014 17:40:40 JLF james      SC00000306
> [...]
>>    T000068581 06/23/2014  8:51:50 JLF james      SC00000204
>>    T000068581 06/23/2014  8:51:50 JLF james      SC00000204
>>    T000000632 06/21/2014 17:40:40 JLF james      SC00000306
>> ──Index─────────────────────────────────────────────────────────────────────────
> [...]
>> When I manually rebuild the index, the index is cleaned up and the phantom,
>> out of place, duplicate records disappear.
> [...]
> 
> You don't have enough information to make a definite diagnosis, but I would 
> start looking at the lookups themselves, and verifying that you are 
> protecting the ones you modify.
> 
> You might want to try PFCHECKLOCK=ON as a start.
> 
> -- 
> Kenneth Brody
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140630/38cbd388/attachment.html