按照帮助编写用户登录窗口(http://www.foxtable.com/help/index.html?n=0395.htm#userconsent#),窗口的AfterLoad事件代码为:
Dim cmd As New SQLCommand
Dim dt As DataTable
Dim cmb As WinForm.ComboBox = e.Form.Controls("UserName")
cmd.ConnectionName = "User"
cmd.CommandText = "SELECX DISTINCT Name From {Users}"
现在想对name增加group删选条件,以下代码都报错,求解,谢谢
cmd.CommandText = "selecX DISTINCT Name From {Users} Where Group = '市场部'"
cmd.CommandText = "selecX DISTINCT Name,group FROM {Users}"
cmd.CommandText = "selecX DISTINCT Group, Name FROM {Users}"