[SAP][ODBC Driver][SQL Anywhere]Table 'INSERTED' not found

[Former Member]

We are upgrading from SQL Anywhere 16 to 17 and I am seeing these errors with our triggers.

The code has been in use through many versions of SQL Anywhere, most recently version 16. This Trigger code has never been an issue until the upgrade.

SELECT @value = ValueFrom FROM INSERTED

SQL Anywhere 17 version: 17.0.4.2503

Searching the docs yields nothing and the release notes mention nothing of these logical tables being removed.

[chris_keating]

I cannot reproduce this in the current release version. Can you try SQL Anywhere 17.0 PL 22 Build 4003.

**NOTE: ** We do not have a publically released 17.0.4.2503 build.

[VolkerBarth]

I bet it should read 17.0.4.2053 - wasn't that the first 17.0.4 build?

[VolkerBarth]

There's one subtle change in v17 w.r.t. triggers relating to trigger order but I don't know whether this has effects on T-SQL triggers like yours as those do not allow for an ORDER clause...

Can you elaborate via MESSAGE / PRINT statements which trigger / part of the trigger code does issue the error message?