topic Re: Case Statement in Application Development and Automation Discussions

Case Statement

Former Member — Thu, 06 Dec 2007 14:50:46 GMT

Is it possible to write a case statement like the following:

Case table_size.

when 0.

when > 0 and < 1000.

when > 1000 and <2000.

when others.

endcase.

Re: Case Statement

Former Member — Thu, 06 Dec 2007 14:52:04 GMT

No, you can not. You have to write If statement in this case.

Regards,

Satish

Re: Case Statement

Former Member — Thu, 06 Dec 2007 14:54:19 GMT

No, I don't think you can use CASE like this

Instead you need to go for IF

-Pavan

Re: Case Statement

JozsefSzikszai — Thu, 06 Dec 2007 15:10:31 GMT

you have to use IF ... :

IF tablesize EQ 0.

...

ELSEIF tablesize GT 0 AND tablesize LT 1000.

...

ELSEIF ...

ENDIF.

hope this helps

Re: Case Statement

Former Member — Thu, 06 Dec 2007 15:11:38 GMT

You can not use the ">" or "<" symbols in the Case statements, they are unknown and will be treated like a field thats been defined by a data statement. Its simply easier to use the conditional IF/ELSE/ENDIF statements when dealing with ranges.