Issue with Index

[daN baueR]

Top Post

Have you considered deleting the index before the post process and
have the index automatically created after the posting process is
done?

Dan

On Mon, Jun 23, 2014 at 12:12 PM, James Flanagan <James at flantec.com> wrote:
> presently, there are only 37 records in the file currently, and on each
> test, i am trying to add or modify 2-3 files.  thanks,
>
>
> 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 23, 2014, at 9:08 AM, daN baueR <dan at onlinemgt.com> wrote:
>
> On Mon, Jun 23, 2014 at 11:14 AM, James Flanagan <James at flantec.com> 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
>   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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> What's the total number of records in the file being posted to? What
> I'm getting at is what's the ratio of new records to existing records?
>
> daN baueR
> dan at onlinemgt.com
>
>