Just anothe detail as I follow the source code the blob field is reaching its point of destruction in a state of nil when the field is declared as ftwidememo and you try to post and edit or an insert operation.

--- In IBObjects@yahoogroups.com, "pb.software" <pb.software@...> wrote:
>
> Jason,
>
> I every bit aware what each subtype does and what it is used for, been doing this for a very long time. I don't think you understood me.
>
> I am declaring a blob field in firebird as a text blob field because I am going to save large amounts of text in that field. Inside delphi when I create the field, persitent, it is created as a widememo and when you connect a dbmemo to it the invalid blob id happens, text blob field to a db memo with ftwidememo. Now if I change the subtype of the persistent blob field to ftblob as if it was linked to a "binary blob", which it is not, it displays the text perfectly and can be modified. If I try to modify the text on a field declared as ftwidememo linked to a text blob field I get an invalid blob id.
>
> The ftBlob field as far as I can remember works with both subtypes of blobs, to get rid of this invalid blob id error I had to change the field type to ftBlob for text blob fields. If I use ftwidememo it crashes the application, more of Invalid Blob ID ISC error 335544...
>
> Pedro
>
>
> --- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@> wrote:
> >
> > Sub-type 1 means text.
> > Sub-type 0 means binary.
> >
> > If you wish to store binary data in a blob, do not use sub-type 1. If IBO
> > allowed this in the past, it was not intentional on my part.
> >
> > Jason
> >
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> > Of pb.software
> > Sent: 08 March 2012 10:12 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] Invalid Blob ID's with IBOQuery
> >
> > There is a problem with the TIBOQuery and blob fields. I have spend two days
> > dealing with this problem at all levels until I finally discovered the
> > problem.
> >
> > I dont understand why a blob field declared as "BLOB SUB_TYPE 1 SEGMENT SIZE
> > 80 CHARACTER SET NONE COLLATE NONE" is created in IBO as a widememo field.
> > It should be created as a TBlobFiled with blobtype of ftwidememo but better
> > yet just a plain ftblobtype which can read any blob format.
> >
> > If I declare a blob field as "BLOB SUB_TYPE 0 SEGMENT SIZE 80" to save
> > binary files, pictures, etc. I can still save text in it and display it. I
> > have never had problems with a plain ftblob type field. This was not the
> > behavior of IBO before, more specific TIBO Class.
> >
> > The ftwidememo implementation is not very compatible with some components
> > which will throw an invalid BLOB ID saving a text memo into a blob field of
> > "BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE COLLATE NONE" while as I
> > discovered after two days if I change the field type manually or create the
> > in code as:
> >
> > qFilesFILE_COMMENTS := TBlobField.Create(Self);
> >
> > It works as expected. Can someone shed some light on this and why are
> > persistent fields being created as widememo instead of regular ftblob?
> >
> > Thanks in advance, Pedro.
> >
>