|Subject||Re: Re: [firebird-support] Re: Stored Procedure as a Function?|
> >> > select foo.col1, xy.outputparamTss - it actually does, sort of, although I currently get a "no current
> >> > from foo
> >> > join xy on foo.col2 = xy.inputparam
> >>I've never seen that syntax and according to my
> >>Firebird install, it doesn't work either.
> This should work instead:
> select foo.col1, xy.outputparam
> from foo
> join someproc(...) xy on foo.col2 = xy.outputparam
fetch operation " - but that might be my Fb version ( WI-T126.96.36.19981
Release Candidate 3)
> I second the idea of CREATE FUNCTION, even though it's only syntacticDisagree - a FUNCTION allows usage without SELECT etc and can be
> sugar AFAICT.
very much more "clean" in this regard.
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.