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