2 Replies Latest reply: Apr 7, 2017 7:47 AM by Do espirito Arnault RSS

    how to test blanc and null values in script

    Do espirito Arnault

      hi every body,

      here is a qw file in witch i try to test blanc or null value :

       

      if INSEE = blanc or null then CODE_DEP_ZMSD = 'HZ'

      if CODE_CANTON blanc or null then CODE_CANTON ='9999'

       

      i've tried ='', =' ', isnull but it doesn't work.

       

      Have somebody an idea ?

      Thank you very much in advance,

       

      Arnault

       

      subsidiary question : why chek box for CODE_DEP_ZMSD doesn't contain a blanc line ( like CODE_CANTON) while it contains blanc or null values.