Subject | Re: [IB-Architect] Select procedures |
---|---|
Author | Jim Boyle |
Post date | 2000-06-08T01:59:25Z |
> Is "{ execute procedure foo }" legal ODBC?Both are legal, but not standard or portable. They
> 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.
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