注册 登录
编程论坛 VB6论坛

vb查询,出现“至少有一个没有被制定“

join窝窝 发布于 2012-05-13 08:40, 281 次点击
Private Sub cmdfind_Click()
    Dim sql As String
    ZhuCe_XueSheng.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb"
    ZhuCe_ = adCmdText
    If Option3.Value = True Then
        sql = "select * from xueji where xh like'" & Text6.Text & "'"
    End If
    If Option4.Value = True Then
        sql = "select * from xueji where xm like '" & "%" & Trim(Text7.Text) & "%" & "'"
    End If
   
    ZhuCe_XueSheng.RecordSource = sql
    ZhuCe_XueSheng.Refresh  ‘问题指向这里
   
   
    Set DataGrid1.DataSource = ZhuCe_XueSheng
End Sub
1 回复
#2
Artless2012-05-15 23:38
以下是引用join窝窝在2012-5-13 08:40:05的发言:

Private Sub cmdfind_Click()
    Dim sql As String
    ZhuCe_XueSheng.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb"
    ZhuCe_ = adCmdText
    If Option3.Value = True Then
        sql = "select * from xueji where xh like '" & Text6.Text & "'"
    End If
    If Option4.Value = True Then
        sql = "select * from xueji where xm like '" & "%" & Trim(Text7.Text) & "%" & "'"
    End If
   
    ZhuCe_XueSheng.RecordSource = sql
    ZhuCe_XueSheng.Refresh  ‘问题指向这里
   
   
    Set DataGrid1.DataSource = ZhuCe_XueSheng
End Sub
1