如何在recordset里按指定条件定位纪录??find方法怎么用?
dim id as integer
dim rs as new adodb.recordset
....
....
id=10
rs.find "id="&id...可是找不到
dim id as integer
dim rs as new adodb.recordset
....
....
id=10
rs.find "id="&id...可是找不到
解决方案 »
- VB树型结构问题
- 连接数据库名的变量
- [请教]客户端表示得画面是VB6,服务器端是Unix下C程序,它们之间是怎么调用得?
- 请问各位高手,如何用VB写智能IC卡的读写程序!!谢谢,我没做过!
- 这样读取行和列有什么问题,请指教
- <求助>扩展名为img的文件怎么打开啊??急
- 有关mshflexgrid问题?????在线等待
- 计算机二级等级考试VB
- zmcpu(CPU),谢谢你的回答,接分 !如何使VB的程序,自己生成 .exe 文件???有难度吧~!高手!!!求助!(visualbasic2000)
- 怎样在Vb6中用程序关闭Help窗口
- 跳楼分: ActiveReports Pro 内如何用脚本实现这样的一个简单功能?
- 网络计费,给指导一下吧,多谢多谢!
rs.Filter="id=" & id
Private Sub Command2_Click()
Dim id As Integer
Dim rs1 As New adodb.Recordset
rs1.Open "select * from orders", conn, adOpenDynamic, adLockPessimistic
id = 3
rs1.Find "订单号=" & id
MsgBox rs1.Fields("供应商")
End Sub
dim rs as new adodb.recordset
....
....
id=10
if rs.recordcount>0 then
rs.movefirst
rs.find "id="&id
if rs.eof then msgbox "沒有找到符合條件的記錄"
else
msgbox "沒有記錄可查找"
end if
查询语句:
mRst.Open "SELECT * FROM tOutput1" & mGetWhere, mConnectString, adOpenKeyset, adLockPessimistic, adCmdText
查询条件函数:
Private Function mGetWhere() As String
Dim mStr As String
If Chk = 1 Then
mStr = "日期>= '" & Format(dtpday.Value, "yyyy-mm-dd") & "' and 日期<= '" & Format(dtpday1.Value, "yyyy-mm-dd") & "'"
End If
'按单号查询
If TextDH.Text <> "" Then
If mStr = "" Then
mStr = "单号 LIKE '" & "%" & TextDH.Text & "%'"
Else
mStr = mStr & " AND 单号 LIKE '" & "%" & TextDH.Text & "%'"
End If
End If
'按供应商查询
If IcbGhdw.Text <> "" Then
If mStr = "" Then
mStr = "外部购货单位 LIKE '" & "%" & IcbGhdw.Text & "%'"
Else
mStr = mStr & " AND 外部购货单位 LIKE '" & "%" & IcbGhdw.Text & "%'"
End If
End If
If Text1.Text <> "" Then
If mStr = "" Then
mStr = "合同号 LIKE'" & "%" & Text1.Text & "%'"
Else
mStr = mStr & "AND 合同号 LIKE '" & "%" & Text1.Text & "%'"
End If
End If
If IcbQf.Text <> "" Then
If mStr = "" Then
mStr = "内部购货单位 LIKE'" & "%" & IcbQf.Text & "%'"
Else
mStr = mStr & "AND 内部购货单位 LIKE'" & "%" & IcbQf.Text & "%'"
End If
End If
If icbCK.Text <> "" Then
If mStr = "" Then
mStr = "出库车间 LIKE'" & "%" & icbCK.Text & "%'"
Else
mStr = mStr & "AND 出库车间 LIKE'" & "%" & icbCK.Text & "%'"
End If
End If
mGetWhere = IIf(Trim(mStr) = "", "", " WHERE " & mStr)
End Function