Are you in a position to install VFP7 and its SP1 and try it? VFP7 itself fixed other things too, and this could be one of them. No way to tell given the paucity of information available on what's fixed and what's still an "issue" in the product.

But for $250 or so, seems well worth the shot, even if for only one special customer in one special case.

good luck



>We are using VFP 6.0
>
>>Dan,
>>
>>What version of VFP are you running?
>>
>>I note that the following is a fix reported for VFP7 SP1:
>>
>>"A filtered index can fail to display records with matching data."
>>
>>good luck
>>
>>
>>
>>>Cindy,
>>>
>>>I found the same Article on MSDN but the problem I am looking for apparently only shows up in Windows 2000 and not Windows 98. I wish I had more to go on but like I said, the gentleman who was told this by microsoft is on vacation for the next two weeks.
>>>
>>>Thanks Dan.
>>>
>>>>>Hi,
>>>>>I'm looking for information on an apparent known bug in Foxpro/Windows 2000 reported to me by a coworker who is now on vacation. He reportedly spoke with an tech a Microsoft about a problem where seek does not find a record that it should. It was supposed to be a known bug with Windows 2000, Visual Foxpro and memory cacheing but I can find nothing about it. Does anyone know about any such bug?
>>>>
>>>>Here's what I found in TechNet. Does this sound like the problem you're referring to?
>>>>
>>>>PSS ID Number: Q135361
>>>>Article last modified on 02-15-2000
>>>>
>>>>WINDOWS:3.0,3.0b,5.0,5.0a,6.0
>>>>
>>>>======================================================================
>>>>-------------------------------------------------------------------------------
>>>>The information in this article applies to:
>>>>
>>>> - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a, 6.0
>>>>-------------------------------------------------------------------------------
>>>>
>>>>SYMPTOMS
>>>>========
>>>>
>>>>When you use the SEEK command and there are trailing spaces in the seek key, the
>>>>seek fails if you previously used this command:
>>>>
>>>> SET COLLATE TO "machine"
>>>>
>>>>However, the seek succeeds if you previously used this command:
>>>>
>>>> SET COLLATE TO "general"
>>>>
>>>>WORKAROUND
>>>>==========
>>>>
>>>>Remove the trailing spaces from the seek key.