convert Binary Stream to BLOB?

  • Thread starter Thread starter roger
  • Start date Start date
R

roger

(repost from ADO DAO group where no one replied)

using MSA2k7
I have 2 subs. that I rewrote from web example code.

sub1 fixes a certain type of broken files I have by open reading it as an
ADO Binary stream, editing the stream and writing it back to the HD.

later sub 2. reads in that file as a BLOB(?) and uses it for something else.

can I just convert the Binary stream into a BLOB directly.

Is it too much to hope for a cBLOB() Method? :)

TIA
 
The following reference says that you can directly convert a stream to a
blob by resetting its Position to 0 and using the ReadText method to
directly load the blob field:

http://www.betav.com/Files/Content/Whitepapers/Using the ADO Stream Object to Manage BLOBs.htm

For the rest of your post, I don't know as I have no idea of what is the
cBlob method. If you are using a recordset opened against Oracle or another
type of specialised recordset, you should give these kind of details.
 
Back
Top