Issue with Index

Richard Kreiss rkreiss at gccconsulting.net
Tue Jun 24 07:08:28 PDT 2014 

If you look at the last column there appears to be a leading space except for:

>    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

I would suggest you check this and then delete index D and then rebuild it.

I have had a running disagreement with Ken on this issue for many years.  When one rebuilds an index, it is cleared and then rebuilt.

When I have had issues with an automatic index, even on rebuild, I have found deleting it and starting over seems to clear up the issue.

Again, check your field 6 to see if there are leading blanks (right justified values) and if there are, correct this first and then rebuild,


Richard Kreiss
GCC Consulting

Office: 410-653-2813



> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of James Flanagan
> Sent: Monday, June 23, 2014 11:14 AM
> To: filePro Mailing List
> Subject: Issue with Index
> 
> 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

More information about the Filepro-list mailing list