注册 登录
编程论坛 VB6论坛

如何修改VB找开access中的文件为指定的fileid

foreversun 发布于 2013-12-07 22:45, 329 次点击
  Set rs = New ADODB.Recordset
    rs.Open "Select * from fileTab where fileid=" & MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 0), cn, adOpenKeyset, adLockOptimistic
当fileid = 7  filename="test.xls时 如何修改
rs.Open "Select * from fileTab where fileid=7 "
报错。
实例在 https://bbs.bccn.net/thread-353402-1-1.html
谢谢
Dim f As String
    Dim rs As ADODB.Recordset
    Dim mstream As ADODB.Stream
    Dim strfileName As String
    On Error GoTo errlab


    Set rs = New ADODB.Recordset
    rs.Open "Select * from fileTab where fileid=" & MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 0), cn, adOpenKeyset, adLockOptimistic

    Set mstream = New ADODB.Stream
    mstream.Type = adTypeBinary
    mstream.Open
    mstream.Write rs.Fields("Filedata").Value

    strfileName = rs("filename")
    mstream.SaveToFile App.Path & "\" & strfileName, adSaveCreateOverWrite
    rs.Close

    Call ShellExecute(0, "open", strfileName, 0, 0, 1)

    Exit Sub
errlab:
    MsgBox "打开文件出错!", vbExclamation, "错误"
2 回复
#2
bczgvip2013-12-08 09:51
    mstream.Open
    rs.movefirst '很多新人都漏了啊?
    mstream.Write rs.Fields("Filedata").Value
#3
foreversun2013-12-08 20:59
  还是不行的
1