6 Replies Latest reply: Jan 7, 2015 2:13 AM by Kamiel Rajaram RSS

    Misleading error message



      A QlikView script has failed citing the following error


      Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '='

      General Script Error

      Execution Failed


      I have attached the code in a .qvw file


      There is no issue with the SQL syntax, and I know this because


      1) If I run the SQL statement in Management Studio it works fine

      3) If I delete the existing .qvd then the routine works fine (the script uses incremental loading)


      Has anyone experienced this type of misleading error message before?


      Are there known issues with incremental loading?  If the exisiting .qvd is corrupt or blank for example.


      Thanks in advance.