我这句SQL语句怎么错了?
在下刚刚开始学习SQL语句,不太懂,请各位指教。
遇到这样的一个问题
Dim SqlString As String
'SqlString = cmbName.Text
If cmbOther.Text = "全部" Then
SqlString = "SELECT * from 变电站10千伏出线电缆资料"
Else
SqlString = "SELECT 站名,线路名称," & cmbOther.Text & " from 变电站10千伏出线电缆资料" ' Where 站名='" & Trim(cmbName.Text) & "'"
End If
Data1.RecordSource = SqlString
Data1.Refresh
就这样执行是正确的,可是我如果把ELSE后面句改成
SqlString = "SELECT 站名,线路名称," & cmbOther.Text & " from 变电站10千伏出线电缆资料 Where 站名='" & Trim(cmbName.Text) & "'"
也即再增加一个条件,怎么在Data1.Refresh就出现错误提示是:syntax error (missing operator) in query expression '站名='江宁'
小的实在是想不通,请各位大哥帮忙解决!!