Skip to Content
0

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

Aug 28, 2017 at 12:18 PM

82

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Chris Keating
Aug 29, 2017 at 06:27 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Volker Barth Aug 29, 2017 at 09:12 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded