Error 1127

"Positioned update operation attempted on a view with an INSTEAD OF trigger"

Item Description

SQLCode

-1127L

Constant

INSTEAD_TRIGGER_POSITIONED

SQLState

42W3B

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2799

Severity Code

15

Probable cause

You attempted a positioned update, positioned delete, put, or wide insert operation that would involve an INSTEAD OF trigger on a view (possibly nested). These operations are not supported with INSTEAD OF triggers on views.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com