Hello friends
is it possible to use case satatement in dialog manager. i am trying to define my fields dynamically and i have to use case statement on one of my fields.

-SET &VAR1= IF &TIMER EQ 'WEEK' THEN ' CASE( DAYNAME(TIME.DLVR_D)
WHEN 'Tuesday' THEN CAST(DLVR_D + 6 DAYS AS CHAR(64))
WHEN 'Wednesday' THEN CAST(DLVR_D + 5 DAYS AS CHAR(64))
WHEN 'Thursday' THEN CAST(DLVR_D + 4 DAYS AS CHAR(64))
WHEN 'Friday' THEN CAST(DLVR_D + 3 DAYS AS CHAR(64))
WHEN 'Saturday' THEN CAST(DLVR_D + 2 DAYS AS CHAR(64))
WHEN 'Sunday' THEN CAST(DLVR_D + 1 DAYS AS CHAR(64))
ELSE CAST(DLVR_D AS CHAR(64))
END' ELSE '';
SELECT &VARI,DLVR_D FROM TIME;
IN MY EXAMPLE IF THE USER ENTERS VALUE FOR TIMER AS WEEK THEN THE CASE STATEMENT SHOULD BE EVALUATED IN SQL.
I TRIED IT BUT ITS GIVING ME ERROR AS MISSING QUOTES OR CASE IS AN EXTERNAL FUNCTION OR COMMAND .

THANKS

When you write a -SET which goes over multiple lines, each new line must begin with a -
for example
-SET &VAR1= IF &TIMER EQ 'WEEK' THEN ' CASE( DAYNAME(TIME.DLVR_D)
- WHEN 'Tuesday' THEN CAST(DLVR_D + 6 DAYS AS CHAR(64))
-etc.

When you forget the - WebFocus treats it as a WebFocus command.
Which is why it thinks your trying to call a subroutine.

Hi jg,
i already tried keeping the - before when but its not working its giving me the same ereror as before.
thanks

What operating system are you using?

Double the quote marks around the days of week (thus:

''Tuesday''

).