4 Replies Latest reply: Nov 28, 2011 1:55 PM by Dennis Hoogenboom RSS

    Set variable value.

         I have set the variable value in query editor.


      SET VarValue = 34;



      and also set this value in the sql where condition.


      select * from



      where  CurrencyyKey = $(VarValue);



      in the designer i used input text box to change the variable value  to populate  table box at the run time but its not changing. may i know where  i am doing wrong or i am missing some steps?