Subject Re: [IBO] Whats Wrong with this?
Author Helen Borrie
At 01:29 AM 21/04/2003 -0400, you wrote:
>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.

This is off-topic for IBO but I'll be kind and answer it. :-))

Use the colon-prefix when you use a variable in an SQL
statement; otherwise not.

Helen