Posted: Wed Apr 07, 2010 9:48 pm
Any helpon my issue
Try - if Trim(NullToEmpty(Out_IRI_UPC.PC_ID))='' then "N/A" else Out_IRI_UPC.PC_ID
DSXchange
A short text to describe your forum
http://dsxchange.com./
APT_CombinedOperatorController,0: Fatal Error: Null value
Page 1 of 1
Posted: Wed Apr 07, 2010 10:41 pm
I'm surprised that no-one has recommended Search to you yet
Try - if Trim(NullToEmpty(Out_IRI_UPC.PC_ID))='' then "N/A" else Out_IRI_UPC.PC_ID
Try - if Trim(NullToEmpty(Out_IRI_UPC.PC_ID))='' then "N/A" else Out_IRI_UPC.PC_ID
Posted: Fri Apr 09, 2010 7:04 am
Hi All,
I used the below code in the transformer. It is working fine.
If trim(nulltovalue(Out_IRI_UPC.PC_ID, ' '))='' then "N/A" else Out_IRI_UPC.PC_ID
I used the below code in the transformer. It is working fine.
If trim(nulltovalue(Out_IRI_UPC.PC_ID, ' '))='' then "N/A" else Out_IRI_UPC.PC_ID