index failure

Scott Nelson scott at logicdatasystems.com
Wed Mar 14 17:41:24 PST 2007


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



More information about the Filepro-list mailing list