Kbase P1124: Getting error 7711 when retrieving data using SELECT * FROM
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2003 |
|
Status: Verified
SYMPTOM(s):
Performing a SELECT * with an ORDER BY
Total length of columns listed is 7K in size
Cannot modify the SQL width of the fields
MM- Row too big (7711)
CAUSE:
The SQL92 engine had to sort a result set and the result set is sorted in a temp table where the physical size of a row in the temp temp is limited to approximately 7K. The size of the record being sorted exceeded that limit.
FIX:
Modify the SELECT statement so that it explicitly lists the fields that need to be in the result set rather than using '*' to retrieve all of the columns