Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Load BLOB field value into a Archive file

edited September 2002 in Server
Hi

I am working with reportable v-6, Delphi V-6 and Sql Server v-8

The front end I created allows users to save the report into the BLOB field
in a table.

Now I wanted retrieve the report back in .rtm format.

Note

The table blob field has many rows, therefore each different user going to
retrieve different blob image.



I find it difficult to load the image field. Into a archive file.

any ideas please



thanks

sharma

Comments

  • edited September 2002


    Perhaps I misunderstand the question, because I do not understand how
    this relates to RB Server.

    A report archive stores the generated report page objects. See the
    article below for storing a .raf file to 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





    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.