Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
huangchao
Contributor III
Contributor III

error of "Incorrect syntax" when doing incremental-load from SQL

Hi,

i am doing incremental-load from SQL...first time, i just learned some scripts from web.

"the_id" is field of figures, just want to bring in new data that "the_id" larger than MaxID in QVD file.

...

SQL SELECT * FROM DB.TABLE

where "the_id" > $(v.MaxID);

...

An error message pop up below:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near > ...

what is reason and possible solution to solve it?

0 Replies