Foxtable(狐表)用户栏目专家坐堂 → [求助]请问数字或双精度小数查找怎么写??


  共有3584人关注过本帖树形打印复制链接

主题:[求助]请问数字或双精度小数查找怎么写??

帅哥哟,离线,有人找我吗?
爱秦宣言
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:幼狐 帖子:65 积分:554 威望:0 精华:0 注册:2019/12/13 9:17:00
[求助]请问数字或双精度小数查找怎么写??  发帖心情 Post By:2020/1/3 21:49:00 [只看该作者]

 请问数字或双精度小数查找怎么写??请大大们来解答~~

"长度","宽度","厚度"为双精度小数,不知道怎么写了

代码如下

Dim filter As String
Dim sts() As String = {"合同号","客户名称","业务员","长度","宽度","厚度","原料产地"}
For Each st As String In sts
    Dim  val As String = e.Form.Controls(st).value
    If val > "" Then
        val = val.Replace("*","[*]")
        If filter = "" Then
            filter = st & " like '*" & val & "*'"
        Else
            filter = filter & " and " & st & " like '*" & val & "*'"
        End If
    End If
Next


Tables("销售合同基础表").Filter = filter
[此贴子已经被作者于2020/1/3 21:51:36编辑过]

 回到顶部
帅哥,在线噢!
有点蓝
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:110581 积分:562801 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2020/1/3 22:09:00 [只看该作者]

Dim filter As String
Dim sts() As String = {"合同号","客户名称","业务员","长度","宽度","厚度","原料产地"}
For Each st As String In sts
    Dim  val As String = e.Form.Controls(st).value
    If val > "" Then
        val = val.Replace("*","[*]")
if TTables("销售合同基础表").cols(st).IsNumeric then
st = "convert(" & st & ",'System.String')"
end if
        If filter = "" Then
            filter = st & " like '*" & val & "*'"
        Else
            filter = filter & " and " & st & " like '*" & val & "*'"
        End If
    End If
Next

 回到顶部