hi,
I have a datastore pointing at a hana 2.x database.
in it, I have template tables.
I can view the data in those tables using data viewer in designer, and jobs are all running without a problem.
However, if I add a filter to the data when viewing it, I get an error, “…syntax error, incorrect syntax near ‘where’: line1…”
when I look at the sql that has been generated it looks like this:
Select where column 1 =‘x’
column 1,
column 2
from mytable
where column 1 = ‘x’.
Why is the first “where” appearing? Anyone else seen this?
Thanks.
wil992 (BOB member since 2011-06-22)