2 Replies Latest reply: Jul 8, 2011 1:44 PM by Miguel Angel Baeyens de Arce RSS

    WHERE & AND in QVD File creation

      Hi to all,

       

      I,m working with QV Perssonal Edition and tryng to create a QVD File "Insert Only", but WHERE & AND Statement does not working, see below the script.

       

      OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=baan;Data Source=baan_10.72.102.100;Extended Properties=""] (XPassword is XXXXXXXXXXXXXXXXXXXXXXXX);

       

      QVD_Table:

      SQL SELECT* FROM BAAN.TTDSLS824804

           WHERE ModificationTime >= #$(LastExecTime)#

           AND ModificationTime<#$(BeginningThisExecTime)#;

       

      Concatenate

      LOAD* FROM Sales.qvd;

      STORE QVD_Table into Sales.QVD;

      How you can see the WHERE & AND are not in BLUE,

      Any Idea abuot why this issue?

      Thanks in Advence......