CREATE PROCEDURE FindSalesAmt
RETURNS (
price decimal(18,2),
id bigint,
description VARCHAR(90)
)
AS
BEGIN
FOR SELECT startprice, itemid, title from ebayrevisefile WHERE price > 20.00
INTO :price, :id, :description DO
SUSPEND;
END
END
Best Regards
========
| ISMAEL |
========
----- Original Message -----
From: Jerry Sands
To: [email protected]
Sent: Friday, November 01, 2013 12:31 PM
Subject: RE: [firebird-support] Problems trying to create Stored Procedure
Change “SUSPEND#” to “SUSPEND;”
From: [email protected]
[mailto:[email protected]] On Behalf Of [email protected]
Sent: Friday, November 01, 2013 11:23 AM
To: [email protected]
Subject: [firebird-support] Problems trying to create Stored Procedure
Good afternoon.
Thank you for taking the time to help me on this. I am new to creating and
using Stored Procedures so please bear with me.
I am trying to create this stored procedure:
SET TERM #;
CREATE PROCEDURE FindSalesAmt(Name VARCHAR(20)) RETURNS (price decimal(18,2),
id bigint,
description VARCHAR(90)) AS
BEGIN
SELECT startprice, itemid, title from ebayrevisefile
WHERE price > 20.00
INTO :price, :id, :description;
SUSPEND#
END#
SET TERM ;#
GRANT EXECUTE ON PROCEDURE FindID to PUBLIC WITH GRANT OPTION;
suspend;
end
And when I compile it I get an error on the set term. As I understand it the
; is a terminator so I need to use a different one within the procedure.
Any help on this is appreciated. I am using Firebird 2.5 with DBVisualizer
Pro 9.0.3.
Thank you!
