On the last leg of migration to FME 2020 from 2018. Was able to clean up a lot of legacy junk - whew! and had a chance to upgrade all relevant workspaces in the process - whoohoo! Starting with a clean slate so to speak. But now I've run into an issue with a SQL Executor that runs some SProc's and does some updates/inserts. This was working with no issues in 2018. Now it complains about the semi-colons:
Semicolons detected in SQL. May need to use FME_SQL_DELIMITER keyword to specify a delimiter.
Then it fails with:
Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement.
Again, I have to ask: anything change from 2018 to 2020 as it pertains to FME_SQL_DELIMITER? Do I have to reformat my statement for Server? Desktop 2020 didn't seem to bother complaining about it. Thanks.
Running MS SQL 2017. FME Desktop/Server 2020.2.