Subject Concatenating Strings in SP
Author Anand
> With the new EXECUTE functionnality introduced in Firebird
> 1.5, yes.
> --
> Olivier Mascia

Thanks, Olivier, for the info :)

I am now facing another problem: How do I concatenate two
strings and store the result in one of the strings used? For
e.g. if I have a VARCHAR variable STR_RESULT in my SP. I want
this variable to take values such as follows:


But when I try something like the above, I get this error:

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Dynamic SQL Error.
expression evaluation not supported.

I can join two absolute string values into a VARCHAR variable,
but if I try to append a string to an existing variable, I get
this error. Is there any way to work around it?

Thanks in advance for any tips and suggestions,


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software