1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SET TERM !! ;
CREATE PROCEDURE usp_Card_Select(ID INTEGER, Nom varchar(50))
RETURNS (Car_id integer, Car_Name varchar(50), Car_Amount decimal(10,2))
AS
BEGIN
if ((:ID is NULL) and (:Nom is null)) then
FOR SELECT Car_id, Car_Name, Car_Amount from Card where Car_State=1
INTO :Car_id, :Car_Name, :Car_Amount
DO
suspend;
else
if (:ID is NULL) then
FOR SELECT Car_id, Car_Name, Car_Amount from Card where Car_State=1 and Car_Name=:Nom
INTO :Car_id, :Car_Name, :Car_Amount
DO
suspend;
else
begin
SELECT Car_id, Car_Name, Car_Amount FROM Card where ID=:ID
INTO :Car_id, :Car_Name, :Car_Amount;
SUSPEND;
end
END !!
SET TERM ; !! |
Partager