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

>yes. currently I do that. But I'm not very happy with it!
>
>Shouldn't that be possible?

No, stored procedure arguments can't be expressions.

/helen

>-----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]
>
>
>
>
>Yahoo! Groups Links
>
>
>
>