Subject | Re: UDFs returning BLOB cause error -804 |
---|---|
Author | mircostange |
Post date | 2002-02-27T13:40:08Z |
> as the return parameter. The real problem is that dsql doesn'thave a
> definition into which to put the output, since it doesn't have anexisting
> blob column to refer to.Ok, got it. In my case I explicitly would not like to store the BLOB
anywhere in the db. I have a table with EMF BLOBs (vector graphs,
small, scalable, ...) but need to convert them into BMPs for printing
(Crystal Reports doesn't like EMFs... beats me why).
I figured out that it works whith a view. I can do
create view sampleattachment_bmp (bmp) as
select emf2bmp(data) from sampleattachment
where "data" would be a blob and emf2bmp would be an udf accepting a
blob and returning one.
I can then easily execute
select bmp from sampleattachment_bmp
Fine!
Regarding the error code. I am using the "old" beta2, mainly because
the RC2 doesn't come with ibconsole, etc. (Why? But this is another
story). Probably this is the cause.
Thank you
Mirco