I have a DRILLMENUITEM in which I will need to execute different procedures based on conditional logic. The condition is whether a '&ID' is empty or not. IF '&ID' is empty THEN execute procedure1 ELSE execute procedure2. How would I do this?

This message has been edited. Last edited by: Kerry,

I think you can do something like this in your style sheet:

TYPE=DATA,
  FOCEXEC=procedure1(),
  WHEN='&ID' EQ '',
$
TYPE=DATA,
  FOCEXEC=procedure2(ID=&ID.QUOTEDSTRING),
  WHEN='&ID' NE '',
$

I think WebFOCUS is a bit picky when dealing with conditional style definitions and requires the use of actual fields in the WHEN clause.

Borrowing Wep5622's example, I've had to do things like this in the past:

DEFINE FILE BLAH
DRILL_IND/A20 = '&ID';
END

TABLE FILE BLAH
PRINT
       FIELD1
       FIELD2
       ...
       DRILL_IND  NOPRINT   <== The field must be used in the request
BY SOMETHING
ON TABLE SET STYLE *
...
TYPE=DATA,
  FOCEXEC=procedure1(),
  WHEN=DRILL_IND EQ '',
$
TYPE=DATA,
  FOCEXEC=procedure2(ID=&ID.QUOTEDSTRING),
  WHEN=DRILL_IND NE '',
$
...
ENDSTYLE
END

Ah true, I forgot about that!

While conditional styling seems to work fine when comparing numeric constants, it can't handle comparisons between string constants for some reason. You have to work around that by providing the constant as a field in the request.

Peculiar really, it would certainly be nice to be able to compare constants (or DM variables, that's the same thing once the stylesheet gets parsed).

It's not that uncommon to want this! The fact that there are known workarounds for this limitation proves that enough.

This may be like an alternative solution but, I have used it in the past by using and IF ELSE logic

TYPE=DATA,
DRILLMENUITEM='CLICK THIS',
-IF &ID EQ '' GOTO PROC1 ELSE GOTO PROC2;
-PROC1
FOCEXEC = PROCEDURE1,
-GOTO ENDIT
-PROC2
FOCEXEC = PROCEDURE2,
-ENDIT
$