Re: SPL problem
the statement
create procedure upd_prop(...)must be followed by ";"
Angel Gomez <angom@hotmail.com> a 'crit dans le message :
7sqrci$ro5$1@news.xmission.com...
Hello. Found this ( check bellow ).
>From: Surfer! <nevis-view@nospam.demon.co.uk>
>Reply-To: Surfer! <nevis-view@nospam.demon.co.uk>
>To: informix-list@iiug.org
>Subject: SPL problem
>Date: Mon, 27 Sep 1999 15:49:01 +0100
>
>Can anyone point out the undoubtedly silly mistake in the following code
>snippet. 'mytable' was created correctly:
>
>=======================================================================
>create table mytable(
> pro_ref char( 16 ),
> app_reg_no integer,
> total_pts integer,
> local_pts integer );>
>
>create procedure upd_prop(
> p_pro_ref like property.pro_ref,
> p_stat like property.stat,
> p_fut_st like property.fut_st )>
> delete from mytable where pro_ref = p_pro_ref;># ^
># 201: A syntax error has occurred.
>#
>
> if ( p_stat = "2" and p_fut_st is NULL )
> or p_fut_st = "4" then
> insert into mytable ( p_pro_ref, TODAY );should be ... insert into mytable VALUES ( p_pro_ref, today );
> end if
>end procedure
>========================================================================
>
>TIA!
>
>--
>Surfer!
Besides that everything is OK.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com