803
社区成员
- 主页
- API 调用
- 基础类
- 控件与界面
- 数据库相关
- DataWindow
- 项目管理
- Web 应用
- 脚本语言
这样的过滤语句是不是PB不允许？
ls_filter = "customershortname like '%value1%' or customershortname like '%value2%'"
li_rc = dw_1.SetFilter(filter)
返回的li_rc值为-1，把like改成=就可以。
...全文
请发表友善的回复…
发表回复
chrisfy 2003-12-12
同意wwwafa9(阿发)
只是把li_rc = dw_1.SetFilter(filter)改为li_rc = dw_1.SetFilter(ls_filter)就行了
只是把li_rc = dw_1.SetFilter(filter)改为li_rc = dw_1.SetFilter(ls_filter)就行了
liliang800207 2003-12-12
试试wwwafa9(阿发) 的
hzhxxx 2003-12-12
zwmc like 'd%' or dm like 'd%' error
zwmc like 'd%' or dm = 'd' error
dm = 'd' and zwmc like 'd%' right
zwmc like 'd%' or dm = 'd' error
dm = 'd' and zwmc like 'd%' right
hzhxxx 2003-12-12
是的，并且 like 要放在后面
wwwafa9 2003-12-12
改成这样行不行？
ls_filter = "(customershortname like '%value1%') or (customershortname like '%value2%')"
ls_filter = "(customershortname like '%value1%') or (customershortname like '%value2%')"
dotnba 2003-12-12
"(customershortname like '%value1%') or (customershortname like '%value2%')"
eminena 2003-12-12
ls_filter = "customershortname like '%"+value1+"%' or customershortname like '%"+value2+"%'"
li_rc = dw_1.SetFilter(filter)
li_rc = dw_1.SetFilter(filter)
mittee 2003-12-12
filter的过滤是有一些限制，为何不修改select语句
cxwsoftware 2003-12-12
同意楼上