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