View references '%1', which is a temporary object. Views can only refer to permanent objects

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

View references '%1', which is a temporary object. Views can only refer to permanent objects

Error constant	SQLE_VIEW_OVER_TEMP_OBJECT
ODBC 2 State	42000
ODBC 3 State	42000
Parameter 1	Temporary object name.
Severity	16
SQLCODE	–766
SQLSTATE	42U00
Sybase error code	4412

Probable cause

Views must refer only to permanent objects, not to temporary objects such as local temporary tables.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1