Yeah I know this is off topic. I needed an answer really quick and I get
faster responses from this newsgroup than the other ones from borland.

I appreciate all your help Helen.

Thanks.
Mo

"Helen Borrie" <helebor@...> wrote in message
news:5.1.0.14.2.20030421162041.040edd70@......

> 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
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>