主题：LoadFilter用法

Dim xs As DataTable = DataTables("销售明细")
xs.LoadFilter = "物资名称 = '" & mc & "' And 规格型号 = '" & xh & "' And 数量 = '" & sl & "' And 不含税单价 = '" & je & "'"

前半段是字符型数据加载没问题，红字部分是高精度小数，总是提示“标准表达式中数据类型不匹配”，求指导

http://www.foxtable.com/webhelp/index.htm?page=1284.htm

按照例子来写，还是不行

Dim mc As String = e.Form.Controls("ComboBox3").value
Dim xh As String = e.Form.Controls("ComboBox4").value
Dim sl As Integer = e.Form.Controls("ComboBox5").value
Dim je As Integer = e.Form.Controls("ComboBox6").value
Dim zh1 As DataTable = DataTables("销售明细")
zh1.LoadFilter = "物资名称 = '" & mc & "' and 规格型号 = '" & xh & "'" 'and 数量 = " & sl & "'"  'and [不含税单价] = " & je & "'"
DataTables("销售明细").Load()

提示：

字符串的语法错误 在查询表达式 '(物资名称 = '橡胶制品*油管' and 规格型号 = 'ZDY-4000LR 4JS076' and 数量 = 10 And [不含税单价] = 1327')' 中。

解决了