Subject RE: [IB-Architect] Select procedures
Author David Schnepper
(Not knowing the ins & outs of ODBC...)

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.


-----Original Message-----
From: Jim Boyle [mailto:jpboyle@...]
Sent: Wednesday, June 07, 2000 4:13 PM
Subject: Re: [IB-Architect] Select procedures

> The question is whether to translate "{ call foo }" into
> "execute procedure foo" or "select * from foo".

"execute procedure foo" for all procs, then use
SQLNumResultCols(...) to check for a result set.
Sybase SQLAnywhere uses this method.




To unsubscribe from this group, send an email to:

[Non-text portions of this message have been removed]