假设数据库中有学生信息表 stud(sno,sname,ssex),其中 ssex 字段已建索引,要输出最后一名男同学的信息,程序空白处应填写的语句是
Private Sub Form_Load()
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source= e:\考试中心教程\教学管理.mdb;"
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.Index = "ssex"
rs.Open "stud" , , , , adCmdTableDirect
________________
Debug.Print rs("sno "), rs("sname "), rs("ssex ")
rs.Close
Set rs = Nothing
End Sub
- A.rs.Find "男", adSeekFirstEQ
- B.rs.Seek "男", adSeekFirstEQ
- C.rs.Find "男", adSeekLastEQ
- D.rs.Seek "男", adSeekLastEQ
热度🔥331
解析:打开微信小程序查看本题解析