topic Re: CASE Statement in Application Development and Automation Discussions

CASE Statement

Former Member — Tue, 04 Sep 2007 10:55:26 GMT

How many WHEN are possible in one CASE from performance point of view?

Re: CASE Statement

Former Member — Tue, 04 Sep 2007 10:57:39 GMT

HI,

NO limit.. you can use any number.

regards,

nazeer

Re: CASE Statement

Former Member — Tue, 04 Sep 2007 10:59:09 GMT

Hi,

You can use as many as WHEN in a single CASE Statment

regards

Sudheer

Re: CASE Statement

Former Member — Tue, 04 Sep 2007 11:08:13 GMT

Thanks for quick response; Eventhough I havenot face any problem for this, I just want to know the limitation. Still, I am not satisfied about the answer - NO LIMIT. As I think, there should be some limit.

Re: CASE Statement

seshatalpasai_madala — Tue, 04 Sep 2007 11:15:24 GMT

Hi,

There is no limit beacuse at once only ONE WHEN will be executed assuming that all your WHEN's are distinct. So you can have as many WHEN's as you want.

Regards,

Sesh

Re: CASE Statement

Former Member — Tue, 04 Sep 2007 13:16:37 GMT

There is of course a limit !! Nothing in the world is without limit !!

However, you should not run into that limit, so even hundrets of cases should work.

Re: CASE Statement

Former Member — Tue, 04 Sep 2007 13:45:07 GMT

to avoid the nested loop case and endcase is there

so there is no limit to whens

you can any number of when

when ever the that values comes then directly control goes to that place so no need to think about performance in this case

reward if usefull

Re: CASE Statement

Former Member — Wed, 05 Sep 2007 06:36:58 GMT

Hi Friendz,

Thanks for responding my question. I got the answer and so I am closing this.

Re: CASE Statement

ThomasZloch — Wed, 05 Sep 2007 10:16:36 GMT

so what on earth is the answer? 42?

Re: CASE Statement

roberto_rodriguez2 — Fri, 07 Jun 2013 12:22:43 GMT

This message was moderated.

Re: CASE Statement

rainer_hbenthal — Thu, 13 Jun 2013 09:14:15 GMT

The limit is the main memory when editing the report.

Re: CASE Statement

ThomasZloch — Thu, 13 Jun 2013 11:23:14 GMT

Please refrain from bumping up my old "jokes"

Re: CASE Statement

RaymondGiuseppi — Fri, 14 Jun 2013 13:27:22 GMT

HG2G rules