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
