以文本方式查看主题 - 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=121561) |
-- 作者:zhy400137 -- 发布时间:2018/7/9 15:01:00 -- In的用法 Dim _UserRoles As String ="财务录单员,微信录单员" Dim Products As List(Of String)= DataTables("授权管理").SQLGetValues("模块","用户标识 In \'" & _UserRoles & "\'","模块顺序") For Each nm As String In Products msgbox(nm) Next 上面的代码用IN不行吗?nm弹不出值
|
-- 作者:有点蓝 -- 发布时间:2018/7/9 15:54:00 -- Dim Products As List(Of String)= DataTables("授权管理").SQLGetValues("模块","用户标识 In \'" & _UserRoles.replace(",","\',\'") & "\'","模块顺序") |