Error 854

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

Item Description

SQLCode

-854L

Constant

INVALID_ORDERBY_COLUMN

SQLState

42W65

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2502

Severity Code

15

Parameter 1

Name of the column referenced directly, or in an expression, in the ORDER BY clause.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com