Re-hi :-)

Unfortunately I found out, that

DECLARE VARIABLE MY_TEXT BLOB sub_type 1 segment size 1024;
...
MY_TEXT = 'Hello';
MY_TEXT = MY_TEXT || ' world';

doesn't work, either?

So, how can I append text to a BLOB variable?

Regards

Jürgen


--- In firebird-support@yahoogroups.com, "frische_brise2003" <juemu@w.
..> wrote:

> Hi all.
>
> I'm modifying text in a a stored proc using a BLOB variable.
>
> Adding text works fine:
>
> DECLARE VARIABLE MY_TEXT BLOB sub_type 1 segment size 1024;
> ...
> MY_TEXT = 'Hello';
> MY_TEXT = MY_TEXT || ' world';
>
> But how can I add a 'carriage return - line feed'?
>
> Regards
>
> Jürgen