以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- [求助]遇到问题了,求组! (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=29504) |
-- 作者:zkysm -- 发布时间:2013/3/8 2:02:00 -- [求助]遇到问题了,求组! 在输入查询代码时候遇到下列问题。我使用TextBox插件来进行查询筛选,我编写的代码是 Dim cpbm As WinForm.TextBox = e.Form.Controls("TextBox1") Dim cpmc As WinForm.TextBox = e.Form.Controls("TextBox2") Dim cpgg As WinForm.TextBox = e.Form.Controls("TextBox3") Dim dw As WinForm.TextBox = e.Form.Controls("TextBox4") Dim cpdj As WinForm.TextBox = e.Form.Controls("TextBox5") Dim gykh As WinForm.TextBox = e.Form.Controls("TextBox6") Tables("产品目录").Filter="TextBox1 like \'*" & cpbm.text & "*\' and TextBox2 like \'*" & cpmc.text & "*\' and TextBox3 like \'*" & cpgg.text & "*\' and TextBox4 like \'*" & dw.text & "*\' and TextBox5 like \'*" & cpdj.text & "*\' and TextBox6 like \'*" & gykh.text & "*\'" 在使用按钮查询时候出现下面错误提示 .NET Framework 版本:2.0.50727.3053 Foxtable 版本:2012.11.28.1 错误所在事件: 详细错误信息: System.Data.EvaluateException: Cannot find column [TextBox1]. at System.Data.NameNode.Bind(DataTable table, List`1 list) at System.Data.BinaryNode.Bind(DataTable table, List`1 list) at System.Data.BinaryNode.Bind(DataTable table, List`1 list) at System.Data.BinaryNode.Bind(DataTable table, List`1 list) at System.Data.BinaryNode.Bind(DataTable table, List`1 list) at System.Data.BinaryNode.Bind(DataTable table, List`1 list) at System.Data.BinaryNode.Bind(DataTable table, List`1 list) at System.Data.DataExpression.Bind(DataTable table) at System.Data.DataExpression..ctor(DataTable table, String expression, Type type) at System.Data.Select..ctor(DataTable table, String filterExpression, String sort, DataViewRowState recordStates) at System.Data.DataTable.Select(String filterExpression) at Foxtable.OOO0OOl111.set_Filter(String O10ll) 请问是那里输入出错了?
|
-- 作者:y2287958 -- 发布时间:2013/3/8 6:20:00 -- like 的前面应该是直接书写列名的,否则要用“&”连接起来。你试试。 |