| 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 |
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.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |