Subject Re: [IBO] Stored Proc Results
Author johnnorthrup34
--- In IBObjects@yahoogroups.com, "Myles Wakeham" <myles@t...> wrote:
> > On 30-Sep-2004 15:54:37, johnnorthrup34 wrote:
>
> > This procedure has a few select statements and three output
> > parameters. I wanted to use a standard Delphi datasource and DBgrid.
> > Is that possible?
>
> I think that the thing you might be getting confused with here is
that any
> stored procedure that returns more than 1 result HAS to be called as
if it
> was a SELECT query. Ie. You would call the stored procedure
GET_THIS_STUFF
> which returns three columns of data back as SELECT * FROM
> GET_THIS_STUF(arguments)
>
> So from the client side perspective, its not a stored procedure - it's a
> query. The only time that, from IBObjects point of view, you would
consider
> it a stored procedure is if it didn't return back values to your
> application.
>
> Regards,
> Myles
>
> ===============================
> Myles Wakeham
> Director of Engineering
> Tech Solutions US, Inc.
> (480) 451-7440
> www.techsol.org

Thank you, this was helpful