Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: How to Write Picture Object (let's say 1.JPG) into BLOB Column?

    How to Write Picture Object (let's say 1.JPG) into BLOB Column?

    Could anyone provide code example?
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Aug 2002
    Posts
    4

    Arrow by the property of adodb.stream

    the code like next list (vb Example) :
    dim cnt as connection
    dim rst as recordset
    dim ste as stream
    'open cnt
    rst.Activeconnection=cnt
    ste.type=adTypeBinary
    ste.open
    ste.loadfromFile=picturePath
    rst.addnew
    rst.fields("theBlobColum").value=ste.read
    rst.update
    set rst=nothing
    cnt.close
    set cnt=nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •