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.

Find settings that give you the supported operations you need with
www.adoanywhere.com/cnet

Also see http://www.adoanywhere.com/ado_faq/supports for some info about
supported operations of recordsets.

--
Michael Collier Bsc (Hons)

Interactive ADO Browser Trial  www.adoanywhere.com/cnet
Free ADO Browser (FAB)  www.adoanywhere.com/fab
Home Page www.adoanywhere.com

--