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.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.