主题：[求助]帮忙分析一下，处理一下，谢谢

我这个句子，每加一个LIKE，查询出来的信息就会少一部分，不知道是什么原因，另外，我一个句子很长，怎么拆分换行呀，

 

Tables("jiankong_table1").Fill("Select ID As 系统编号,changjia As 客户,pici As 批次,songdanwei As 单位,pinpai As 屏品牌,xinghao As 屏型号,bianma As 屏编码,xuliehao As 屏序列号,beijianid As 备件条码,leibie As 类别,guzhang As 原始故障,danjuzhuangtai as 单据状态 From main where id like '%" & bh.text & "%' and beijianid like '%" & bj.text & "%' and xinghao like '%" & xh.text & "%' and changjia like '%" & kh.Text & "%' and pici like '%" & pc.text & "%' And danjuzhuangtai Like '%" & dj.Text & "%' and zjzhuangtai Like '%" & zjzt.Text & "%' and jieshoujigou = '" & _UserGroup & "'","User",True)

 like会剔除空值。你要这样写，比如 (id like '%%' or id is null)

 

 换行看这里 http://www.foxtable.com/help/topics/2489.htm

 

我按照操作换行不行啊，老大，上面的那条，你帮我改改，谢谢

同时满足那么多个条件,数据肯定比条件少的少.

 换行，比如这样改

 

Tables("jiankong_table1").Fill("Select ID As 系统编号,changjia As 客户," _
& "pici As 批次,songdanwei As 单位,pinpai As 屏品牌," _
& "xinghao As 屏型号,bianma As 屏编码,xuliehao As 屏序列号,beijianid As 备件条码,leibie As 类别,guzhang As 原始故障,danjuzhuangtai As 单据状态 From main where id Like '%" & bh.text & "%' and beijianid like '%" & bj.text & "%' and xinghao like '%" & xh.text & "%' and changjia like '%" & kh.Text & "%' and pici like '%" & pc.text & "%' And danjuzhuangtai Like '%" & dj.Text & "%' and zjzhuangtai Like '%" & zjzt.Text & "%' and jieshoujigou = '" & _UserGroup & "'","User",True)

换行的好用，终于解决了我的那么长的句子的问题了，呵呵，现在正在研究查询，数量老是查询的不准确 还是LIKE的问题

就我现在的这个查询条件，能否帮忙优化一下呢？谢谢

就一直AND 你要查那么多个条件的话.没得优化.

 

like问题，请按照2楼修改。

LIKE包括空值，查询到的记录会有好多空值