Hi,
so there may have been a bug in my SQL (I'm not convinced) I tried to fix it and it still didn't work then I cleared the sql in the Where clause and it still reported a error.
I then created a new sql reader from the same DB connection and got an error.
next I replaced the DB connection. the older reader that had the sql in the where clause still reported an error.
the newer reader that never had sql in the where clause works. both report that they are using the DBconnection 'GISDW_test.
the older one has the error:
Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT Lmirn], ryear], astate], treadingType], pmaxFlow], ojanDays], yjan], afebDays], yfeb], emarDays], ymar], aaprDays], yapr], pmayDays], ymay], ajunDays], yjun], ujulDays], yjul], uaugDays], yaug], usepDays], ysep], eoctDays], yoct], cnovDays], ynov], odecDays], ydec], eslope], pintercept], pr2], rcount], nregressionComment], nqualityFlag] FROM Synergi.eMIRN_YEAR_REGRESSION_test] WHERE FME_SQL_DELIMITER ;
SELECT * FROM Synergi.eMIRN_YEAR_REGRESSION_test] WHERE Wyear] = 2019 and 9state] = 'VIC';
'. Provider error `(-2147217900) An expression of non-boolean type specified in a context where a condition is expected, near ';'.'
but there is not code in the where clause.
Whats going on?
cheers