Subject | help Store Procedure |
---|---|
Author | Luis Adrián Amato |
Post date | 2003-11-29T21:30:18Z |
Wrong ?
CREATE PROCEDURE SP_INC (
SUCUR INTEGER,
INCREMENTO DECIMAL (2, 2))
AS
BEGIN
if (incremento <> 0) then
BEGIN
UPDATE SUC_ART SET PRECIO=PRECIO*:INCREMENTO
WHERE ID_SUC= :SUCUR ;
SUSPEND;
END
END
I must run a store procedure than update al the recordos from a
SUCURSAL and increment the PRICE (PRECIO) with a PORCENT
I don't know whats wrong with this?
CREATE PROCEDURE SP_INC (
SUCUR INTEGER,
INCREMENTO DECIMAL (2, 2))
AS
BEGIN
if (incremento <> 0) then
BEGIN
UPDATE SUC_ART SET PRECIO=PRECIO*:INCREMENTO
WHERE ID_SUC= :SUCUR ;
SUSPEND;
END
END
I must run a store procedure than update al the recordos from a
SUCURSAL and increment the PRICE (PRECIO) with a PORCENT
I don't know whats wrong with this?