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


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

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

帅哥,在线噢!
有点蓝
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:110582 积分:562806 威望: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

 回到顶部