index failure

[John Esak]

Scott,

The indexes in filePro are trustworthy... I can think of very, and I mean
very few times over 27 years when an actual "real" problem has shown up...
and upon such errors the problem was immediately fixed. The only way to
procede on your problem is to put up the data and the index. Send it to
fpsupport at fptech.com.  They will fix it for you.

I have no guesses other than the value of PFIXS (either off or on??) and the
possibility that a number just before the desired number is corrupt. Both
will probably yeild not much... you may actually have a serious "real" index
problem... but like I say, it will be a very rare instance.

John


> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.com]On
> Behalf Of Scott Nelson
> Sent: Wednesday, March 14, 2007 9:41 PM
> To: FilePro Mailing List
> Subject: index failure
>
>
> fp 5.0.13 on sco 5.06
> system running for years
> index A - field 1  size 9  edit .2
> index re-built nightly
> looking for value of 34350.04  using index A - resulting in Not Found
> scan file for field 1 with same value - finds record
> no input or auto process on this file
> finds records for larger and smaller numbers using same index
> no data corruption in file when scanning thru records
> did update on record and typed number again
> still not found
> erased index and re-built
> still not found.
>
> if indexes are not trustworthy, basic functions of fP are not reliable.
>
> any ideas??????
>
>
> Scott Nelson
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list