yes. currently I do that. But I'm not very happy with it!

Shouldn't that be possible?

-----Ursprüngliche Nachricht-----
Von: Helen Borrie [mailto:helebor@...]
Gesendet: Freitag, 27. Februar 2004 10:26
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Question about calling a procedure


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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]