Ok.

BTW, one of the examples of the .NET driver documentation is precisely
how to insert a text value (possibly more than 32K) into a text BLOB .



Jordi.



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Thursday, March 15, 2007 11:05 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] how to use BLOBs



At 09:53 PM 15/03/2007, you wrote:

>
>
>Hi all,
>
> Could anyone post an example of how to store and retreive CLOBs (BLOB
>subtype TEXT) using procedural SQL or similar?

Why using procedural SQL? You can store and retrieve blobs (text or
otherwise) directly with DSQL.

select MyBlob from MyTable
where ....

insert into MyTable (ID, MyBlob)
values (?, ?)

For BLOB sub_type 1 (TEXT), the blob argument can take a string of
32,765 bytes or less. This is more (or less) useful, provided you
are not trying to store strings that might be larger than that.

>Any hints on how to perform the same operation through the .NET driver?

I think this is what you really need to know, since BLOB operations
use a different API structure from the one for regular
data. Subscribe to the firebird-net-provider list. All the
list-subscribe instructions are at
http://firebirdsql.org/index.php?op=lists
<http://firebirdsql.org/index.php?op=lists>

./heLen





[Non-text portions of this message have been removed]