Question Re: [SAP][ODBC Driver][SQL Anywhere]Table 'INSERTED' not found in Technology Q&A

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

Former Member — Mon, 28 Aug 2017 12:18:28 GMT

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.

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

VolkerBarth — Tue, 29 Aug 2017 09:12:38 GMT

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?

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

chris_keating — Tue, 29 Aug 2017 18:27:12 GMT

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.

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

VolkerBarth — Wed, 30 Aug 2017 09:39:02 GMT

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