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

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

A CONTAINS query is not allowed on the view or derived table '%1'

Error constant SQLE_TEXT_INVALID_VIEW_FOR_CONTAINS
ODBC 2 State ERROR
ODBC 3 State ERROR
Parameter 1 The name of the view or derived table that cannot be queried with CONTAINS.
Severity 16
SQLCODE –1283
SQLSTATE WT020
Sybase error code 13791
Probable cause

A view or derived table can only be queried using CONTAINS if it does not use TOP, FIRST, DISTINCT, GROUP BY, or FOR XML. In addition, the list of columns to search must all come from a single base table in the FROM clause of the view. They cannot come from multiple tables, or from another view or derived table in the FROM clause.