(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.

Dave


-----Original Message-----
From: Jim Boyle [mailto:jpboyle@...]
Sent: Wednesday, June 07, 2000 4:13 PM
To: IB-Architect@egroups.com
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.




_____

<http://click.egroups.com/1/5276/4/_/830676/_/960419538/>
<http://adimg.egroups.com/img/5276/4/_/830676/_/960419538/468mcsearch.gif>


_____

To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com






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