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 (D-K)

 

Function or column reference to '%1' in the ORDER BY clause is invalid

Error constant SQLE_INVALID_ORDERBY_COLUMN
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the column referenced directly, or in an expression, in the ORDER BY clause.
Severity 15
SQLCODE –854
SQLSTATE 42W65
Sybase error code 104
Probable cause

You specified a function or column reference in the ORDER BY clause that is semantically invalid. For example, for DISTINCT queries the ORDER BY clause may only refer to items in the query's select list.