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.
>
> R. S. Patil