Subject Re: [IBO] Retrieve blob text from dynamic query fails, why?
Author hamacker
Hummm, my edition is Trustware and last version is 5.5.3.2068, no higher version for me :)
I test blobStream.Size and always returns 0 size.

I have to wait a new version to resolv this.

2014-10-22 17:26 GMT-02:00 'Luiz' cprmlao@... [IBObjects] <IBObjects@yahoogroups.com>:
 

Hi,

 

I have 2095 version.

I have tested your code and I found no problem.

I tested creating the tib_query in design time, no runtime.

var 

  blobStream:TIB_BlobStream;  

begin

  m.Open;

  blobStream:=m.CreateBlobStream(m.FieldByName('sinopse'), bsmRead);

  memo1.Lines.LoadFromStream(blobStream); // always empty

  FreeAndNil(blobStream);

(...)

 

Luiz

 

De: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Enviada em: quarta-feira, 22 de outubro de 2014 14:46
Para: Lista IBObjects
Assunto: [IBO] Retrieve blob text from dynamic query fails, why?

 

 

Hi, everybody.

 

My Delphi is XE5 and IBO 5.5.3_2068, every time that I need to retrieve blob text data from a field, as bellow, fail.

 

var 

  blobStream:TIB_BlobStream;  

  m:TIB_Query;

begin

  m:=TIB_Query.Create(Self);

  (...)

  m.Open;

  blobStream:=m.CreateBlobStream(m.FieldByName('sinopse'), bsmRead);

  memo1.Lines.LoadFromStream(blobStream); // always empty

  FreeAndNil(blobStream);

(...)

 

To workaround I change to:

memo1.Lines.Text:=m.FieldByName('sinopse').AsString;

But I dont know if is correct retrieve blob text using AsString.

 

But I would like to know, why fails using blobStream?