>>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
Actually, with ANSI ON, records would be returned where that field value is empty if you have no spaces between the quotes. In his example, one would hope no data gets returned.
Mark McCasland
Midlothian, TX USA