First, check whether you might have a corrupted index (do a reindex).

For debugging, you might look at the SQL output from the view, and try some simpler versions. Add one element at a time, or a few, to see what happens.

>Hi,
>
>The problem happen when I use Promatrix framework, but it is actually a common VFP view problem so I post it here in order to seek for extra and faster help.
>
>I have a search view which always come up empty when it suppose to have 1 record!
>
>The search view's SELECT command reads:
>

>SELECT Stblcomp.compnam1, Stblcomp.compnam2, Stblcomp.compsnam, Stblcomp.compnick, Stblcomp.comprobn 
>FROM ustb!stblcomp 
>WHERE ( ( (  Stblcomp.compnam1 = ( ?GETcompnam1 ) AND  Stblcomp.compnam2 = ( ?GETcompnam2 ) ) 
>AND  Stblcomp.compsnam = ( ?GETcompsnam)) AND  Stblcomp.compnick = ( ?GETcompnick ) ) 
>AND  Stblcomp.comprobn = ( ?GETcomprobn )
>

>
>Though it has 5 filter variables in it, the one that will be actually used in my test is Stblcomp.compnam1 = ( ?GETcompnam1 )
>The view is opened with USE command in the framework:
>

	
>	USE (slcViewName) ALIAS (slcAlias) &slcClauses 
>	
>	* The below IF structure below are inserted by me
>	* V_RIDUP is the alias that I use to open the above search view
>	IF slcAlias = [V_RIDUP]  
>		SET STEP ON 	
>		BROWSE
>	ENDIF
>

>
>When the SET STEP ON bring up the debugger:
>In the debugger 's LOCAL window:
> slcAlias is [V_RiDup]
> slcClauses is ""
> GETcompnam1 is "Highclass Computer Software "
> GETcompnam2 is "%"
> GETcompsnam is "%"
> GETcompnick is "%"
> GETcomprobn is "%"
>
>In the debugger's WATCH window:
> ALIAS() is [V_RIDUP]
> EOF() is .T.
> BOF() is .T.
> SET("EXACT") is "OFF"
> LEN(stblcomp.compnam1) is 40
> LEN(GETcompnam1) is 40
>
>The BROWSE after the SET STEP ON as shown above always come up empty... that is the view has no data in it.
>However, If I browse directly the underlying table stblcomp which the above view is based on I can find a record whose compnam1 field is "Highclass Computer Software "
>
>I really can't find where could be the error that cause the view to open up empty, it should contain 1 record
>Anything else that I could have missed? or any tips on debugging this kind of error?
>
>Btw,
>if I try to change the filter Stblcomp.compnam1 = ( ?GETcompnam1 ) to Stblcomp.compnam1 LIKE ( ?GETcompnam1 ), the view come up with 1 record. But I can't use LIKE here because the search view is used to check for duplicated field values.