index failure

[Jay R. Ashworth]

On Thu, Mar 15, 2007 at 08:28:53AM -0400, Kenneth Brody wrote:
> Quoting Scott Nelson (Wed, 14 Mar 2007 17:41:24 -0800):
> 
> > fp 5.0.13 on sco 5.06
> > system running for years
> > index A - field 1  size 9  edit .2
> > index re-built nightly
> 
> Why?
> 
> > 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
> 
> What do you mean "did update on record"?  Does it find that value
> before you update the record?
> 
> > still not found
> > erased index and re-built
> > still not found.
> [...]
> 
> If you have a repeatable failure on freshly-built indexes, contact
> fpsupport and arrange to send files.

Is it possible he could be having the same Index Scan problem I am?  Or
is that specific to date fields?

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274