Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Function '%1' has invalid parameter '%2' ('%3') Next Page

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


Item

Value

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.