2 Replies Latest reply: Mar 23, 2012 5:42 AM by Juan Vitantonio RSS

    Is it possible to use QV functions in SQL and inline

      I know variables can be used in SQL & inline.

      E.g:

      [Code]

      let var_1 = 1;

      sql_tab:

      SQL select name from employee where id=$(var_1);

      inline_tab:

      load * inline [

      test

      $(var_1)

      ];

      [/Code]

       

      But, that means I have to define many variables, too many variables will be hard to management.

      So, is it possible to use QV functions in SQL & inline? Below is the example, but it doesn't work.

      E.g:

      [Code]

      sql_tab:

      SQL select * from emp_salary where salary_date=Date#('2012-01-01','YYYY-MM-DD'); //highlighted in red is a function of QV

       

      inline_tab:

      load * inline [

      test

      Date#('2012-01-01','YYYY-MM-DD')

      ];

      [/Code]


      I also tried using $() around the QV function, not work.