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

Select lists in UNION, INTERSECT, or EXCEPT do not match in length Next Page

SELECT returns more than one row


Item

Value

Constant

SQLE_TOO_MANY_RECORDS

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Severity

16

SQLCODE

-185

SQLSTATE

21000

Sybase error code

13637

Probable cause

You tried to use a SELECT statement without a cursor, but the statement cursor returns more than one row. Only a single row SELECT statement can be used in this context.