vfp模糊查的
SelFilter= ".T. "
IF.NOT.EMPTY(ALLTRIM(THISFORM.name_ch.VALUE))
SelFilter=SelFilter+ "AND ' " + ALLTRIM(THISFORM.name_ch.VALUE)+ " ' $ name_ch "
ENDIF
SELECT user
SET FILTER TO &SelFilter
查的果在GRID1中示
行模糊查,果好像不太正常,例如我有,一的name_ch是王五,另一是王明,我在文本框入王行查是,一都不示,用五行查,出王五。什么用共同的字行查有果呢?
[解决办法]
SelFilter= ".T. "
IF.NOT.EMPTY(ALLTRIM(THISFORM.name_ch.VALUE))
lcString=ALLTRIM(THISFORM.name_ch.VALUE)
SelFilter=SelFilter+ "AND ' "+lcString+ " ' $ name_ch "
ENDIF
SELECT user
SET FILTER TO &SelFilter