>I create a parentheses remote view via VFP ODBC :
>
>SELE * FROM custOr WHERE cusID = ?mCusId
>
>If mCusId = '' then the remote view only return data with cusid = ''.
>
>But I test the above command with locate view, mCusId = '' will return all data.
>
>Any wrong with my progrom??
>
>TIA.
I think, it might be a difference in SET ANSI settings. Try SET ANSI OFF - will return all data. SET ANSI ON should return no data
If it's not broken, fix it until it is.
My Blog