http://www.ibphoenix.com/a4556.htm
http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm

In case you are interested in knowing more.

-----Original Message-----
From: Doug Chamberlin [mailto:yahoogroups@...]
Sent: Monday, October 20, 2003 2:08 PM
To: firebird-support@yahoogroups.com; firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How to obtain isc_db_handle and
isc_tr_handle


At 10/20/2003 04:01 PM (Monday), Robert DiFalco wrote:

>That's kinda sad. I read all this great stuff about using blob streams
>(i.e. bstreams) but we have no sanctioned way of using them in a UDF. I
>guess we can only use segmented blobs in UDFs?
>
>But I'm open to suggestions, how would you work with a streamed blob in
>a UDF?

I don't what a bstream is. Sounds like something from embedded SQL?

Blobs are blobs in the database - I don't think there is a distinction
between segmented BLOBs or BLOB streams in the database, itself. How you

access the BLOBs may differ but that depends on your client operating
environment. I stream to and from BLOB fields in my client application
all
the time. I use Delphi under Win32.

UDFs are a supplement to SQL which enables clients to extend the
manipulation of fields beyond what the built-in SQL functions provide.
SQL
provides almost no support for manipulating BLOB fields and that is
where
the paucity of BLOB support you feel probably comes from. However, I
think
some people have written UDFs which accept BLOB fields as parameters and

return modified BLOBs as results but I have not used those UDFs.

If you need to manipulate BLOBs within your SQL statements then I
suggest
you look for those UDF libraries. If you want to stream BLOBs to/from
your
client applications then that should be easier since I think all
middleware
layers support it. Perhaps I'm wrong about that.





Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.