topic error of &quot;Incorrect syntax&quot; when doing incremental-load from SQL in QlikView https://community.qlik.com/t5/QlikView/error-of-quot-Incorrect-syntax-quot-when-doing-incremental-load/m-p/736220#M263419 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i am doing incremental-load from SQL...first time, i just learned some scripts from web. </P><P></P><P>"the_id" is field of figures, just want to bring in new data that "the_id" larger than MaxID in QVD file.</P><P></P><P>...</P><P>SQL SELECT * FROM DB.TABLE</P><P>where "the_id" &gt; $(v.MaxID);</P><P>...</P><P></P><P>An error message pop up below:</P><P></P><P><STRONG>ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near &gt; ...</STRONG></P><P></P><P>what is reason and possible solution to solve it?</P></BODY></HTML> Thu, 30 Oct 2014 18:11:12 GMT huangchao 2014-10-30T18:11:12Z error of "Incorrect syntax" when doing incremental-load from SQL https://community.qlik.com/t5/QlikView/error-of-quot-Incorrect-syntax-quot-when-doing-incremental-load/m-p/736220#M263419 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i am doing incremental-load from SQL...first time, i just learned some scripts from web. </P><P></P><P>"the_id" is field of figures, just want to bring in new data that "the_id" larger than MaxID in QVD file.</P><P></P><P>...</P><P>SQL SELECT * FROM DB.TABLE</P><P>where "the_id" &gt; $(v.MaxID);</P><P>...</P><P></P><P>An error message pop up below:</P><P></P><P><STRONG>ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near &gt; ...</STRONG></P><P></P><P>what is reason and possible solution to solve it?</P></BODY></HTML> Thu, 30 Oct 2014 18:11:12 GMT https://community.qlik.com/t5/QlikView/error-of-quot-Incorrect-syntax-quot-when-doing-incremental-load/m-p/736220#M263419 huangchao 2014-10-30T18:11:12Z