Query >IF

[mpowell_esq]

Hi Talkers,
What is the syntax for having a query in a browse with an IF statement? eg FOR EACH table WHERE IF clause THEN display.
Regards

 

[dacl]

Here is an example (freeform query):


DEFINE BROWSE brw_detail
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS brw_detail WINDOW-1 _FREEFORM
QUERY brw_detail NO-LOCK DISPLAY
(IF NOT v_klantreferenties
THEN vkcontract_dtl.artikelcode
ELSE vkcontract_dtl.klantartikel)
COLUMN-LABEL "Artikel":C12 FORMAT "X(15)":U
/* _UIB-CODE-BLOCK-END */

&ANALYZE-RESUME

WITH NO-ROW-MARKERS NO-COLUMN-SCROLLING SEPARATORS SIZE 84.29 BY 10

BGCOLOR 15 FONT 4.

 

[prog_user]

Do you know how to do the same for Schema triggers

I'm looking to achieve the following code in Desktop2 version of eB2:


ON LEAVE ANYWHERE DO:
if frame-field = 'so_nbr' then do:
display frame-value.
end.
END.

I would really appreciate it if you could please show how to do this in a way that Desktop2 understands ??

Rgds,
Ashley