Subject | Re: [IBO] Stored Proc Results |
---|---|
Author | Myles Wakeham |
Post date | 2004-10-01T05:58:01Z |
> On 30-Sep-2004 15:54:37, johnnorthrup34 wrote:I think that the thing you might be getting confused with here is that any
> This procedure has a few select statements and three output
> parameters. I wanted to use a standard Delphi datasource and DBgrid.
> Is that possible?
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