"A CONTAINS query is not allowed on the view or derived table '%1'."
| Item | Description |
|---|---|
|
SQLCode |
-1283L |
|
Constant |
TEXT_INVALID_VIEW_FOR_CONTAINS |
|
SQLState |
WT020 |
|
ODBC 2 State |
ERROR |
|
ODBC 3 State |
ERROR |
|
Sybase Error Code |
2970 |
|
Severity Code |
|
|
Parameter 1 |
The name of the view or derived table that cannot be queried with CONTAINS. |
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.