Hello,

when I use:

FETCH FIRST FROM STATCURSOR  INTO ZWISCHEN1,ZWISCHEN;


                    WHILE NOT EOF(STATCURSOR) DO
                    IF ZWISCHEN1 < 5 THEN  UPDATE STATCURSOR SET STATUS1  = 'FÄLLIG';
                    END IF;
                    FETCH NEXT FROM STATCURSOR INTO ZWISCHEN1,ZWISCHEN;
                    END WHILE;

it works.

with CASE

                   WHILE NOT EOF(STATCURSOR) DO
                    CASE zwischen1
                    when  < 5 THEN  UPDATE STATCURSOR SET STATUS1  = 'FÄLLIG';
                    END CASE;
                    FETCH NEXT FROM STATCURSOR INTO ZWISCHEN1,ZWISCHEN;
                    END WHILE;

The Error is: 700 Expected expression but instead found <

Is this with CASE not possible?

TIA
Dieter

Dieter

From my understanding of looking at the OLH there are two formats for CASE. The long version is essentially the same as a series of IFs with the full test for each WHEN and with the short version CASE is essentially an equality operator a bit more like the Delphi approach.

Mind you I sort of like your attempt - it seems rather neat.

Roy Lambert [Team Elevate]

Roy,

thanks, I will do it with IF, but with many ifs it's not so easy

Dieter












Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Dieter

From my understanding of looking at the OLH there are two formats for CASE. The long version is essentially the same as a series of IFs with the
full test for each WHEN and with the short version CASE is essentially an equality operator a bit more like the Delphi approach.

Mind you I sort of like your attempt - it seems rather neat.

Roy Lambert [Team Elevate]