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

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

SELECT returns more than one row

Error 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.