Re: CASE statement frustration...
Sean Kelsey said:
> IDS 9.40.TC4 (on Windows 2000 Advanced Server)
>
>
> Afternoon all...
>
> Can anyone tell me why the folloiwng CASE statement embedded within a
> SPL won't work? Its really bugging me.
>
> TIA.
>
> Sean.
>
> CREATE PROCEDURE MIS_DoTest()>
> DEFINE v_test INTEGER;
> DEFINE v_res VARCHAR(12);
>
> LET v_test = 1;
> LET v_res = '0';
>
> CASE v_test
> WHEN THEN
> LET v_res = '1';
> WHEN 1 THEN
> LET v_res = '2';
> WHEN 2 THEN
> LET v_res = '3';
> ELSE
> LET v_res = 'else';
> END CASE;
>
> END PROCEDURE;
Errrr.... something is missing in the first "WHEN" clause?
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
http://www.catb.org/~esr/faqs/smart-questions.html
sending to informix-list