Subject RE: [IBO] IB_Stored procedure
Author Jason Wharton
Actually, you are probably better off avoiding this and just using a
TIB_DSQL component. That way it is explicitly clear you are intending this
to only be a single-row operation. TIB_StoredProcedure is just kind of a
lazy man's way to complicate things for himself.

Jason Wharton
www.ibobjects.com


> -----Original Message-----
> From: Rick Roen [mailto:rick@...]
> Sent: Wednesday, December 01, 2004 7:11 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] IB_Stored procedure
>
> I'm struggeling with the IB_StoredProcedure component in Delphi 7.
>
> Probably like most other IB components it is simpler than I am
> making it, but I need to learn how to use it.
>
> I have a stored procedure that returns one line for an account
> ageing. There are no suspends in the SP.
>
> I want to do something like "Select * from P_Account_Ageing
> (:Custnum)" and have it get the parameter Custnum from the Customer
> table.
>
> Are there some general instructions for this or an example?
>
> TIA
>
> Rick