Subject Re: [ib-support] Appending data to Blob
Author Ivan Prenosil
> I have a blob that handles long strings. Usually I append strings using
> Delphi but how do I append a string in a procedure?
>
> I hoped it would be as simple as my example but I get error message
> "conversion error from string "BLOB"
>
> UPDATE akt SET noteringar = noteringar || 'jenny'
> WHERE aktid = 2509
>
> I use Interbase 5.6 and the blob is subtype 1 segment size 80.

You need UDF to do it. You can find some free blob libraries here:
http://www.cvalde.com/misc/packages_and_utilities.htm


Ivan
http://www.volny.cz/iprenosil/interbase