Subject Re: [IB-Architect] Select procedures
Author Jim Boyle
> Is "{ execute procedure foo }" legal ODBC?
> Is "{ select * from foo(params) }" legal ODBC?
>
> If one of those forms is legal, and the other not, then "{ call foo }"
> should go to the "illegal" form.
> If both form are legal, then from an application programmer viewpoint *I*
> would expect more
> the "execute procedure foo" type of behavior.

Both are legal, but not standard or portable. They
will work if the underlying driver supports that
syntax (I say it should) and SQLSetStmtOption
SQL_NOSCAN is set right. But common client
programs that you can't change like Crystal Reports
may not work this way.

Jim