>Hi,
>
>We seem to be having a problem with seek not finding records.
>
>We perform the seek on a table with a that has an index on a char(13) field, and although the record exists, the seek command and the locate command are not finding them. I've even tried using Locate with the NOPTIMIZE clause, but this is also doesn't find the record. What is funny, is if I scatter the record, delete it ( and blank all values), then append a blank and gather into this, the seek command works.
>
>Is there a known bug? and what is the work around - apart from scatter and gather.
>
>Thanks
>
>Macer
Sounds to me like you've got data corruption. Use a good tool like FoxFix or Stonefield to correct the problems then rebuild all your indexes.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer