Subject | Whats Wrong with this? |
---|---|
Author | StinkyDuck |
Post date | 2003-04-21T05:29:07Z |
SET TERM ^ ;
CREATE PROCEDURE MO(
VMONTH SMALLINT)
AS
BEGIN
IF (:VMONTH = 1) THEN
EXECUTE PROCEDURE SP_MO2;
END;
^
SET TERM ; ^
I get an error Invalid Command. If I take the ':' from VMONTH it works.
Whats the proper syntax.
CREATE PROCEDURE MO(
VMONTH SMALLINT)
AS
BEGIN
IF (:VMONTH = 1) THEN
EXECUTE PROCEDURE SP_MO2;
END;
^
SET TERM ; ^
I get an error Invalid Command. If I take the ':' from VMONTH it works.
Whats the proper syntax.