是不是ADO无法识别出前面的SQL语句,感觉WuPin like ...后面的逻辑有点重复. {"select * from db_sysinfo where DingDanBianHao>='2010030001' and DingDanBianHao<='2010040001' and WuPin like '%子%' and YeWuYuan='yw1' order by DingDanBianHao DESC"}
我去掉了后面两个like还是一样,另外我没有绑定字段,只是设置两个简单的组合主键
select * from db_sysinfo where DingDanBianHao>='2010030001' and DingDanBianHao<='2010040001' and (WuPin like '%子%' or WuPin like '子%' or WuPin like '%子') and YeWuYuan='yw1' order by DingDanBianHao DESC
{"select * from db_sysinfo where DingDanBianHao>='2010030001' and DingDanBianHao<='2010040001' and WuPin like '%子%' and YeWuYuan='yw1' order by DingDanBianHao DESC"}