Private Sub Command1_Click()Dim objcon As New ADODB.Connection
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\student.mdb"
SQL = "select * from info where " & Combo1.Text & " =' " & Text1.Text & "'"
objrs.Open SQL, objcon, 1, 1If objrs.EOF = True Then‘输出数据语句(省略)Unload MeElse: MsgBox "没有找到相关记录!", , "提示"End If
End SubCombo1是一个组合框,用来选择查询的类型;Text1用来输入查询的条件。
当我输入一个已知的数据查询时,会提示出错:BOF或EOF中有一个是“真”,或者当前的记录被删除。请问问题出在哪??请大家帮帮忙~谢了~~
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\student.mdb"
SQL = "select * from info where " & Combo1.Text & " =' " & Text1.Text & "'"
objrs.Open SQL, objcon, 1, 1If objrs.EOF = True Then‘输出数据语句(省略)Unload MeElse: MsgBox "没有找到相关记录!", , "提示"End If
End SubCombo1是一个组合框,用来选择查询的类型;Text1用来输入查询的条件。
当我输入一个已知的数据查询时,会提示出错:BOF或EOF中有一个是“真”,或者当前的记录被删除。请问问题出在哪??请大家帮帮忙~谢了~~
set objrs=new adodb.recordset
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source= " & App.Path & "\student.mdb "
SQL = "select * from info where " & Combo1.Text & " = '" & Text1.Text & "'"
if objrs.state<>adstateclosed then objrs.close
objrs.Open SQL, objcon, adopenkeyset,adlockreadonly
if objrs.recordcount>0 then
‘输出数据语句(省略)
objrs.close
lbjcon.close
Unload Me
Else
MsgBox "没有找到相关记录! ", , "提示 "
objrs.close
End If
End Sub
SQL语句第2个单引号多了个空格,应改为:
SQL="select * from info where " & Combo1.Text & "= '" & Text1.Text & " ' "谢谢各位啦。结帖!!