以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- SQLGetComboListString (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=102424) |
-- 作者:qaz -- 发布时间:2017/6/19 17:20:00 -- SQLGetComboListString SQLGetComboListString语句的Filter参数支持两个条件吗? |
-- 作者:qaz -- 发布时间:2017/6/19 18:02:00 -- Dim ck As WinForm.ComboBox = e.Form.Controls("站名") Dim ck1 As WinForm.ComboBox = e.Form.Controls("电压等级") Dim ck2 As WinForm.ComboBox = e.Form.Controls("班级") If ck1.Text<>""then ck.ComboList=DataTables("电能表台账").sqlGetComboListString("站名","班级=\'"& ck2.Text &"\'" And "电压等级=\'"& ck1.Text &"\'") Else ck.ComboList=DataTables("电能表台账").SQLGetComboListString("站名","班级=\'"& ck2.Text &"\'") End If
|
-- 作者:有点色 -- 发布时间:2017/6/19 18:07:00 -- ck.ComboList=DataTables("电能表台账").sqlGetComboListString("站名", "班级=\'" & ck2.Text & "\' And 电压等级=\'" & ck1.Text & "\'") |