index failure

[Kenneth Brody]

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.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com