0 Replies Latest reply: Nov 28, 2011 9:14 AM by Dan-Ketil Jakobsen RSS

    Using EDX with variables

    Dan-Ketil Jakobsen

      Hi

       

      I have a solution where we use EDX for manually update.

      This works allmost as planned.

       

      My problem is that I have 3 varaiables that needs to be updated on each load.

      vBatchStartTime, vBatchStopTime, vTag

      Examle:

      '11-11-2011 10:00:00',

      ''11-11-2011 11:00:00',

      '3201L50H007.PV','3201L50H008.PV'

       

      This is then put into yet another variable:

      LET vSQL = 'EXEC master.dbo.xp_AnalogWideHistory ' & vBatchStartTime & ', ' & vBatchStopTime & ', ' & 100000 & ', ' & vTag;

       

      SQL $(vSQL);

       

      When I hit the button I can see, in some textboxes, that the different variables changes.

      The result is shown in a trend line.

      The problem is that this does not happend att all.

      If I add the code below it works.(I can also remove the edx totaly, but then the button will not work from client)

      ActiveDocument.Reload

      ActiveDocument.Reload (Not sure why I need it twice, but I do)

       

       

      How can I get EDX to parse variables as well.

      I found one example, but it seems to only handle one variable, and a predefined variable

      http://community.qlik.com/message/160822#160822

       

      Anybody got any comments or ideas on how to solve this?

       

      Dan