VFP SQL200 LIKE 查询时字段中间有“-”时查询不到?该怎么处理
VFP SQL200 LIKE 查询时字段中间有“-”时查询不到?
VFP SQL200 LIKE 查询时字段中间有“-”时查询不到?
------解决方案--------------------
应该是可以的,请分别试试如下:
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE ?X1","TEMP")
or
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE 'FW-%'","TEMP")
or
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE '%FW-%'","TEMP")
------解决方案--------------------
就你贴出的语句来看,我不相信没有 - 时能查到数据而不报错
VFP SQL200 LIKE 查询时字段中间有“-”时查询不到?
------解决方案--------------------
应该是可以的,请分别试试如下:
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE ?X1","TEMP")
or
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE 'FW-%'","TEMP")
or
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE '%FW-%'","TEMP")
------解决方案--------------------
就你贴出的语句来看,我不相信没有 - 时能查到数据而不报错