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

> -----Original Message-----
> From: Rick Roen [mailto:rick@...]
> Sent: Wednesday, December 01, 2004 7:11 PM
> To:
> 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?
> Rick