3 Replies Latest reply: Jul 16, 2012 5:19 PM by Oldrich Hlavacek RSS

    Parameter and empty value

      Hello,

      I'm QlikView begginer. I can reload QVW with many different databases. I can set the database by command line parameter:

      "c:\Program Files\QlikView\qv.exe" /r /vDB=DB1 j:\QLIKVIEW\DEVELOPMENT\TEST.qvw

       

      In case the parameter is'nt set (by reload from Desktop), I can use the deafult database.

       

      I have this line before connect to database:

      IF (Len(Trim(DB))=0 or IsNull(DB)) THEN

        SET SetDB = 'DB0';

      ELSE

        SET SetDB = $(DB);

      ENDIF;

       

      Then I connect to SetDB database.

      But... SetDB is already set as DB0, so script don't take the value from parameter DB. Do you see some mistake? Can you help me?

      Many thanks,

      Olda