- Foxtable(狐表) (http://foxtable.net/bbs/index.asp)
-- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2)
---- [求助]模糊搜索，出现错误提醒 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=85237)
-- 发布时间：2016/5/20 23:24:00
-- [求助]模糊搜索，出现错误提醒
“搜索”按钮，代码如下：
Dim txt As WinForm.TextBox = e.Form.Controls("TextBox1")
Tables("订购单总").Filter = "[订购单号] Like \'%" & txt.text & "%\' or [订购单供应商] like \'%" & txt.text & "%\' or [金额] like \'%" & txt.text & "%\'"
Cannot perform \'Like\' operation on System.Double and System.String.
此主题相关图片如下：123.gif
-- 发布时间：2016/5/21 9:16:00
--
数值型列不能用like
& "%\' or [金额] = " & txt.text
-- 发布时间：2016/5/22 11:41:00
--
Tables("订购单总").Filter = "[订购单号] Like \'%" & txt.text & "%\' or [订购单供应商] like \'%" & txt.text & "%\' or Convert([金额],\'System.String\') like \'%" & txt.text & "%\'"