iAnywhere.com - SELECT returns more than one row

SQL Anywhere® 10 - Error Messages > Database Error Messages > Alphabetic list of error messages

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.