When I do CTRL L to verify my event code, I get errors that indicates MSOLEDBSQL throws a SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near 'xxx'
Yet, when I run this code connecting to this database, the code works, the imbedded sql works. What suggestions do you have to fix this issue?
My database used in this profile in my IDE is the same database that is used in the code when I run or debug the app. Below is the proof. However, there is a change I made on the settings on the syntax tab that added the DelimitIdentifier setting, which looks like the lack of it was the cause of the compile errors. Thanks for pointing me in the right direction.
Here you can see when I debug this code, it has already executed this UPDATE code that flags as having syntax errors, and there is no error returned when the code is run.
