sql语法问题 急！！！！！十万火急！

来源：百度知道 编辑：UC知道 时间：2024/05/17 06:36:33
Private Sub Command1_Click()
bxr = Trim(Text1.Text)
bxsj = Trim(Text2.Text)
bxbm = Trim(Text3.Text)

If bxr <> "" And bxsj <> "" And bxbm <> "" Then
sqlsel = "select * from weixiu where 报修人='" & Trim(Text1.Text) & "' and 报修时间='" & Trim(Text2.Text) & "' and 部门='" & Trim(Text3.Text) & "'"
End If
If bxr = "" And bxsj <> "" And bxbm <> "" Then
sql = "select * from weixiu where 报修时间='" & Trim(Text2.Text) & "' and 部门='" & Trim(Text3.Text) & "'"
End If
If bxr <> "" And bxsj = "" And bxbm <> "" Then
sqlsel = "select * from weixiu where 报修人='" & Trim(Text1.Text) & "' and 部门='" & Trim(Text3.Text) & "'"
End If
If bxr <> "&

如果是日期时间型的变量要在前后各加一个#

如:

sql = "select * from weixiu where 报修时间='#" & Trim(Text2.Text) & "#' and 部门='" & Trim(Text3.Text) & "'"

SQLserver日期型数据是用单引号无疑。
属性使用无效,问题可能出在连接上。