At 12:42 AM 8/10/2003 +0000, you wrote:

>--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
>wrote:
>
> > Actually, SPs are made for applications, not users, and
>
>don't do tricks, you know very well that somebody must write them
>(the SPs), hopefully w/o suffering too much :)
>
> > Maybe, but the assumption is wrong. The SELECT works on output,
>not input.
>
>sure, but I can write
>
>select ... from foo('a' || 'b')
>
>while I cannot write
>
>execute procedure foo('a' || 'b')
>
>It is silly.

What's your environment? Here I created both procs (naming the second one
foo1) and both worked with your execution statements - hence proving my
account of your problem wrong - at least for 1.5.

This was with both ISQL and IB_SQL.

> > Exactly. That's why you write applications for users.
>
>I have to satisfy my users and I do that well enough (well, up to a
>point) :)

I believe every word you say. ;-)

h.