At 10:17 AM 27/02/2004 +0100, you wrote:

>if I call a procedure in a trigger or in another procedure, for example with
>
>EXECUTE PROCEDURE MY_PROCEDURE('test');
>
>it is not possible to calc or to add strings together in the parameter.
>Something like
>
>EXECUTE PROCEDURE MY_PROCEDURE('test' || :FmyLocalVar);
>
>does not work! Firebird (1.0) says: "Token unkown ||")
>
>What can I do?

Declare a variable of a suitable type, assign your computed value to that
and use the variable as your input parameter instead.

/heLen