Issue with Index

James Flanagan James at Flantec.com
Mon Jun 23 08:14:26 PDT 2014


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
   T000003517 06/21/2014 18:11:33 JLF james      R000000018
   T000003522 06/21/2014 18:11:41 JLF james      R000000018
   T000003526 06/21/2014 18:11:50 JLF james      R000000018
   T000004000 06/21/2014 18:12:03 JLF james      R000000018
   T000004149 06/21/2014 18:20:41 JLF james      R000000019
   T000003999 06/21/2014 18:56:40 JLF james      R000000022
   T000003998 06/21/2014 18:24:31 JLF james      R000000020
   T000003997 06/21/2014 18:26:18 JLF james      R000000020
   T000068580 06/21/2014 21:54:58 JLF james      R000000030
   T000000153 06/23/2014  0:57:02 JLF james      R000000038
   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─────────────────────────────────────────────────────────────────────────
        UP / DOWN -Change Record  Enter -Select Record  U -Update Record
                 S -Set Selection  Z -fuZZy Search  R -Reset  C -Continuous On
                         F -Format  H -Hardcopy  X -Exit

When I manually rebuild the index, the index is cleaned up and the phantom, out of place, duplicate records disappear.  

                     I N Q U I R E,  U P D A T E,  A D D            5.7.00.04D4
────────────────────────────────────────────────────────────────────────────────
   T000000073 06/17/2014 18:28:02 JLF james      R000000013
   T000000501 06/21/2014 17:38:58 JLF james      R000000014
   T000003517 06/21/2014 18:11:33 JLF james      R000000018
   T000003522 06/21/2014 18:11:41 JLF james      R000000018
   T000003526 06/21/2014 18:11:50 JLF james      R000000018
   T000004000 06/21/2014 18:12:03 JLF james      R000000018
   T000004149 06/21/2014 18:20:41 JLF james      R000000019
   T000003998 06/21/2014 18:24:31 JLF james      R000000020
   T000003997 06/21/2014 18:26:18 JLF james      R000000020
   T000003999 06/21/2014 18:56:40 JLF james      R000000022
   T000068580 06/21/2014 21:54:58 JLF james      R000000030
   T000000153 06/23/2014  0:57:02 JLF james      R000000038
   T000000099 06/23/2014  8:46:07 JLF james      R000000043
   T000068581 06/23/2014  8:51:50 JLF james      SC00000204
   T000000632 06/21/2014 17:40:40 JLF james      SC00000306
   T000000500 06/21/2014 17:40:40 JLF james      SC00000306
      ***** END OF FILE *****

──Index─────────────────────────────────────────────────────────────────────────
        UP / DOWN -Change Record  Enter -Select Record  U -Update Record
                 S -Set Selection  Z -fuZZy Search  R -Reset  C -Continuous On
                         F -Format  H -Hardcopy  X -Exit

This behavior is keeping my lookups for working properly.  Thank you in advance for your time and attention to this. 

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140623/84c7d3a2/attachment.html 


More information about the Filepro-list mailing list