> 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:

STR_RESULT = 'START';
STR_RESULT = :STR_RESULT + ' PROCESSING ...';
STR_RESULT = :STR_RESULT + ' END';

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,

Anand

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com