rst.Open "select * from BlobTab1", cnDb, adOpenDynamic, adLockOptimistic
For i = 2 To 10
rst.AddNew
rst("cid") = i
rst("cpic") = mstream.Read
rst.Update
Next如果不使用存储过程 完全没有问题
For i = 2 To 10
rst.AddNew
rst("cid") = i
rst("cpic") = mstream.Read
rst.Update
Next如果不使用存储过程 完全没有问题
Dim tempSql As String
tempSql = "您的存储过程名 '" & 参数1 & "','" & 参数2& "'"
cnDb.Execute tempSql
tempSql = "InsertBlobTab1 " & 11 & "," & mstream.Read & ""
cnDb.Execute tempSql〉〉无效sql语句
用insert先给blob插入null值,在用update更新流的方式完成新增