Subject | Executing a procedure |
---|---|
Author | yaedos2000 |
Post date | 2004-12-08T17:03:40Z |
Hi, I'm using a selectable stored procedure to obtain a list of ID
numbers as follows:
SET TERM ^ ;
CREATE PROCEDURE TEST
RETURNS (
ID_NUM VARCHAR(15))
AS
begin
/* Procedure Text */
SELECT HACID FROM TBL_HACS INTO :id_num;
suspend;
end
^
SET TERM ; ^
Which IB component should I use to execute this procedure, and how do
I store the returned results into variables in Delphi 7?
Thanks
numbers as follows:
SET TERM ^ ;
CREATE PROCEDURE TEST
RETURNS (
ID_NUM VARCHAR(15))
AS
begin
/* Procedure Text */
SELECT HACID FROM TBL_HACS INTO :id_num;
suspend;
end
^
SET TERM ; ^
Which IB component should I use to execute this procedure, and how do
I store the returned results into variables in Delphi 7?
Thanks