I am use IBO 3.6, D5 and Firebird, but not find any problems in work with
BLOB fields...
May be you has mistake in source code?

WBR, Dmitry Beloshistov AKA [-=BDS=-]
e-mail: torin@...

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, August 08, 2001 8:49 PM
Subject: Re: [IBO] Blob Fields Not Fetched ?


> I don't know why this wouldn't work. Can you send me a sample privately so
I
> can fix this?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "R. S. Patil" <rspatil@...>
> To: "IBO News Group (Yahoo)" <IBObjects@yahoogroups.com>
> Sent: Saturday, August 04, 2001 3:32 AM
> Subject: [IBO] Blob Fields Not Fetched ?
>
>
> > I am Using IBO 3.6x, D5, firebird.
> >
> > in IB_query the sql is
> > select
> > photo,
> > sign,
> > address,
> > ...
> > from
> > get_PIDInfo(:PID_NO)
> >
> > where get_PIDinfo is a sp which returns the required info
> >
> > Photo, sign are defined as Blob subtype 0 segment 2048, and
> > address is are defined as Blob subtype 1 segment 2048
> >
> > i have tested sp with ibexpert and it shows all the fields
> > properly
> >
> > when query is opened run time all other fields except blob
> > type are shown properly in respective native controls but
> > for all blob fields isNull is true (tested in debug window)
> >
> > otherwise if i select directly from tables these fields are
> > shown properly. Why i changed these to sp is to reduce the
> > prepare time for that query. with query the prepare time was
> > 3800+ ms now its 800-900ms with sp
> >
> > can somebody help me in this regard why blob fields are not
> > fetched when sp is used.