Dim conn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim stmcon As New Stream
Dim strsql As String
conn.Open conStr stmcon.Type = adTypeBinary
stmcon.Open
stmcon.LoadFromFile "F:\劳资照片\05106657.JPG" If rst.State = adStateOpen Then rst.Close strsql = "select * from photo " rst.Open strsql, conn, adOpenDynamic, adLockOptimistic
rst.AddNew rst.Fields("PHOTO").Value=stmcon.read
rst.Update stmcon.Close
Set stmcon = Nothing
以上代码中把jpg 格式的图片导入到oracle中,但是出现了错误,为什么啊?出现错误为不支持rst.addnew的方法啊
Dim rst As New ADODB.Recordset
Dim stmcon As New Stream
Dim strsql As String
conn.Open conStr stmcon.Type = adTypeBinary
stmcon.Open
stmcon.LoadFromFile "F:\劳资照片\05106657.JPG" If rst.State = adStateOpen Then rst.Close strsql = "select * from photo " rst.Open strsql, conn, adOpenDynamic, adLockOptimistic
rst.AddNew rst.Fields("PHOTO").Value=stmcon.read
rst.Update stmcon.Close
Set stmcon = Nothing
以上代码中把jpg 格式的图片导入到oracle中,但是出现了错误,为什么啊?出现错误为不支持rst.addnew的方法啊
最好把出错的详细信息帖出来
Dim rst As New ADODB.Recordset
Dim stmcon As New Stream
Dim strsql As String
conn.Open conStr
conn.CursorLocation = adUseClient stmcon.Type = adTypeBinary
stmcon.Open
stmcon.LoadFromFile "F:\劳资照片\05106657.JPG" rst.CursorLocation = adUseClient
If rst.State = adStateOpen Then rst.Close strsql = "select * from photo where 1=2" rst.Open strsql, conn, adOpenStatic, adLockOptimistic, adCmdText
rst.AddNew rst.Fields("PHOTO").Value=stmcon.read
rst.Update stmcon.Close
Set stmcon = Nothing
//这里是否会错?
从语法来看没错。
strsql = "select * from photo "
rst.Open strsql, conn, adOpenDynamic, adLockOptimistic
stmcon.Type = adTypeBinary
stmcon.Open
stmcon.LoadFromFile "F:\劳资照片\05106657.JPG"
rst.AddNew
rst.Fields("PHOTO").Value=stmcon.read
rst.Update
stmcon.Close
Set stmcon = Nothing
2.如 vbman2003(家人) 所说的,注意表字段的数据类型