Thanks Helen !

But now, I see, another problem..

It's the first time that I work with Blobs in an SP.. the BLOB Result aways
out blank !! :(

If I do some like BLOB_Variable=VARCHAR_Variable; the server return me an
error when I execute "Unsuccessful execution caused by a system error that
precludes....". If i make and concatenation like VARCHAR_Variable1 || ' - '
|| VARCHAR_Variable2 the error don't ocurrs but it return me blank... :(

I tried to make an Cast to blob but it don't run..

What happen ???

Thanks !!!
Tiago Gouvês

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, August 02, 2004 8:22 AM
Subject: Re: [firebird-support] Line Break in SP


> At 08:07 AM 2/08/2004 -0300, you wrote:
> >Hi all !
> >
> >I need to make and 3 lines BLOB output in an SP.. How can I make an line
> >break into it ??? Like #10+#13 in Pascal...
>
> There are several ways, but the easiest is just to hit the Enter key
> between two string-markers, something like this:
>
>
> declare returnchar char(2) '
> '
> Then, during the procedure, when you want to add a line break, just
> concatenate the variable to the end of the string:
>
> blobstring = blobstring || stringx || returnchar;
>
> /heLen
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>