5 Replies Latest reply: Jul 17, 2014 6:22 AM by Ralf Becher RSS

    WHERE CLAUSE WITH A VARIABLE

    rainer battisti

      Hi, who can help me.

      I want to use a WHERE clause during a load of a file where I check a field with a variable assigned value before the script execution starts

      Example: if I start in this way

       

      qv.exe /r /vMyvar=123 abc.qvw

       

      let Myvar = '';

       

      load Field1,

              Field2

      [from c:\tmp\Test.txt]

      WHERE (Field1 = Myvar);

      But an error occurs during the load. It don't recognise the variable Myvar