以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 数组的in操作报错 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=158035) |
-- 作者:guosheng -- 发布时间:2020/11/5 15:55:00 -- 数组的in操作报错 Dim Lst As New List(Of String) cmd.CommandText = "S elect [ccode],[ccode_name],[iyear],[bend],[bbank],[bcash] F ROM {code} where bbank=0 And bcash=0 and ccode In (\'" & String.join("\',\'",Lst.tparray) & "\') And iyear=" & val(e.Form.Controls("DateTimePicker1").value) |
-- 作者:有点蓝 -- 发布时间:2020/11/5 16:00:00 -- ToArray:http://www.foxtable.com/webhelp/topics/0217.htm |