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 type on DESCRIBE statement Next Page

Invalid use of an aggregate function


Item

Value

Constant

SQLE_AGGREGATES_NOT_ALLOWED

ODBC 2 State

37000

ODBC 3 State

42000

Severity

15

SQLCODE

-150

SQLSTATE

42W06

Sybase error code

13204

Probable cause

You attempted to use an aggregate function inappropriately. For example, a SELECT statement cannot contain an aggregate function within a predicate in the WHERE clause unless the aggregate function constitutes an outer reference. Other invalid uses include specifying an aggregate function in the SET clause of an UPDATE statement, or using an aggregate function in a CHECK constraint.