Subject Re: [firebird-support] Re: weird behaviour [typo corrected]
Author Helen Borrie
At 12:42 AM 8/10/2003 +0000, you wrote:
>--- In, Helen Borrie <helebor@t...>
> > 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. ;-)