Contents Index Frame not allowed in window '%1' Function or column reference to '%1' must also appear in a GROUP BY

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

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


Item Value
SQLCODE -854
Constant SQLE_INVALID_ORDERBY_COLUMN
SQLSTATE 42W65
Sybase error code 104
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.
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.


Contents Index Frame not allowed in window '%1' Function or column reference to '%1' must also appear in a GROUP BY