Hi Macer,

The collation sequence has been implicated in some troubles like this.

Good luck,

Jim N

>>>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.
>
>
>Since, getting these problems all indexes are regualarly deleted and rebuilt - without much success unfortunately.