Odag and Nulldisplay

Simona-07 — Sat, 16 Nov 2024 03:39:36 GMT

Hi,

I have a problem with NULLDISPLAY function during app ODAG generation. Null values don't get converted to 'Not Available'. Please refer to the following snippet:

Set NULLDISPLAY = 'Not Available';

NoConcatenate
DETTAGLIO:
LOAD *,
$(v_complementary_fields);
SQL SELECT
$(v_Load)
FROM TABLE
$(WHERE_PART) and ($(WHERE_PART_TIPOLOGIA_ANALISI))
;

Where:

$(v_Load) are the selected fields

$(v_complementary_fields) are the same fields extracted by $(v_Load) renamed

$(WHERE_PART) and $(WHERE_PART_TIPOLOGIA_ANALISI)are parametric where conditions submitted to the DB.

Please note that a similar script runs without using ODAG and Null values are correctly converted to the default value.

Can you tell me if NULLDISPLAY (or NullAsValue) and ODAG are incompatible?

I tried to look online but I couldn't find any document regarding Odag and NULLDISPLAY (Or NullAsValue) compatibility.

Thanks

topic Odag and Nulldisplay in App Development

Odag and Nulldisplay