Blob Field

rbuser

I have in my Firebird 1.53 Database a Table with a Blob Field to store my
template file.

It is BLOB SUB_TYPE 0 SEGMENT SIZE 400.

Which is best Sub_Type and Size to complex reports with many image, one of
it is 1950kb ?

Thank You

nicocizik

Hi Vincenzo,

This is the sub_type and segment size we use in our Interbase demo. Are you
running into problems with this configuration?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I need to save my template in a BlobField in my personal Table. I am using
this code but it doesn't work fine.

var
aRep: TMemoryStream;
begin
try
aRep := TMemoryStream.Create;
ppReportEuro.Template.SaveToStream(aRep);

FBDataREP.Edit;
FBDataREPREPORT.LoadFromStream(aRep);
FBDataREP.Post;
finally
aRep.Free;
end;

When I try to load it to open ppDesigner I get an "Format" error .

var
aRep: TMemoryStream;
begin
try
aRep := TMemoryStream.Create;
FBDataREPREPORT.SaveToStream(aRep);
ppReportEuro.Template.LoadFromStream(aRep);

ppDesigEuro.Show;
finally
aRep.Free;
end;
end;

nicocizik

Hi Vincenzo,

You need to reset the stream position before loading it. For instance...

aRep.Position := 0;
ppReportEuro.Template.LoadFromStream(aRep);


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com