Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Gerhardus Geldenhuis" <gerhardus@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, October 02, 2002 3:08 AM
Subject: Re: [IBO] Difference between using ib_query or ib_storedproc for a
select procedure


> Lucas Franzen wrote:
> >
> > Gerhardus Geldenhuis schrieb:
> >
> >>Hi
> >>I just want to know is there any difference in terms of
> >>speed/effectiveness/etc in using a ib_query to, with the following
> >>select * from myproc(:var1,:var2) than using a ib_storedproc component
> >>to do the selection.
> >
> >
> > TIB_Query are for returning multiple rows, so your SP must contain
> > SUSPEND to return multiple rows.
> > IB_StoredProcs are for returning ONE row (a set of fields) and the SP
> > shouldn't contain SUSPEND in that case.
> >
> > Luc.
> >
>
> Yes true, but as I understand you can use IB_storedproc to also return
> multiple rows just like a normal dataset. So for me it is unclear which
> one would be better to use.
>
> I did include suspend in my storedproc.
>
> Groete
> Gerhardus
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>