Subject | Re: [IBO] Whats Wrong with this? |
---|---|
Author | Helen Borrie |
Post date | 2003-04-21T06:22:55Z |
At 01:29 AM 21/04/2003 -0400, you wrote:
Use the colon-prefix when you use a variable in an SQL
statement; otherwise not.
Helen
>SET TERM ^ ;This is off-topic for IBO but I'll be kind and answer it. :-))
>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.
Use the colon-prefix when you use a variable in an SQL
statement; otherwise not.
Helen