
Current RecordSet does not support updating Oracle 8
Hello,
While inserting a blob into a long field I get this error
"Current RecordSet does not support updating. This may be a limitation of
the provider , or of the selected locktype ."
Set rs = New ADODB.Recordset
Set msStream = New ADODB.Stream
rs.Open "Select syh_contents,syh_length from sysadm.sy_history where
syh_key =" & nMyKey, mvarConn, adOpenKeyset, adLockOptimistic
msStream.Type = adTypeBinary
msStream.Open
msStream.LoadFromFile "c:\tmp.jpg"
rs.Fields("syh_contents").Value = msStream.Read
rs.Fields("syh_length").Value = msStream.Size
rs.Update
mvarConn.CommitTrans
Does somebody know what to do about this ?
Greetings,
Filip W.