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

Invalid option '%1' -- no PUBLIC setting exists Next Page

Invalid ORDER BY specification

Item

Value

Constant

SQLE_INVALID_ORDER

ODBC 2 State

37000

ODBC 3 State

42000

Severity

15

SQLCODE

-152

SQLSTATE

53005

Sybase error code

108

Probable cause

Either you used an integer in an ORDER BY list and the integer is larger than the number of columns in the select list, or you specified an ORDER BY expression that is semantically invalid. For example, with UNION queries you can only use integers to specify an ordering of the result.