Save a document to a BOLB Field

rbuser

Hi!

My name is Sharma
(New to the User group)

I am really great full to any of you, if you could share some of your
knowledge and experience with me.



I am using Delphi version -6, Sql Server 8, Report Builder 6

User front end developed with Delphi 6 and tables are stored in the SQL
Server

I am trying to store a document generated using Report builder into the BOLB
field in the server.

Is it possible? If yes

Please any ideas

Thanks

Sharma

nardmoseley

I assume you are wanting to use the ArchiveVolume component that enables
collections of report archives to be added to the server's report
catalog. The archives can be stored to (.raf) files or to a database
blob.

The following tech tip is from the Tech Tips newsgroup and describes how
to store load an archive file into a database BLOB.


--------------------------------------------------
Tech Tip: Loading an Archive File to a Blob
(or memory stream)
---------------------------------------------------

You can easily write a routine to take a .RAF file and
load it into a blob field or a TMemoryStream:

myFileStream := TFileStream.Create('myArhcive.RAF', fmOpenRead);

myFileStream.Position := 0;
myBlobField.LoadFromStream(myFileStream);

myFileStream.Free;


OR

myMemoryStream := TMemoryStream.Create;

{note: passing 0 as the second parameter will copy the entire stream}
myMemoryStream.CopyFrom(myFileStream, 0);

myMemoryStream.Free;


--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com