Issue with Index
daN baueR
dan at onlinemgt.com
Tue Jun 24 13:55:47 PDT 2014
I believe he specified that was a 10 character field. Which would rule out
a leading space.
Dan
On Tuesday, June 24, 2014, Richard Kreiss <rkreiss at gccconsulting.net> wrote:
> 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
> <javascript:;>
> > [mailto:filepro-list-bounces+rkreiss <javascript:;>=
> verizon.net at lists.celestial.com <javascript:;>] 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 <javascript:;>
> >
> > aim: Flantec
> > oovoo: Flantec
> > Skype: Flantec
> > ichat: Flantec at mac.com <javascript:;>
> >
> > 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 <javascript:;>
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com <javascript:;>
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
--
daN baueR
dan at onlinemgt.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140624/e502bb07/attachment.html
More information about the Filepro-list
mailing list