Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 29, 2017 at 06:27 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 29, 2017 at 09:12 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded