Kbase P46338: error 141 with 4GL Dynamic Query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/01/2005 |
|
Status: Unverified
SYMPTOM(s):
Dynamic Query cause error 141
** Index value is too long. (141)
When using a BY clause on an OPEN QUERY statement, if the field specified in the BY clause has a value greater than the documented limit, then the 141 error appears.
CAUSE:
The maximum length for the sum of values in an index key is 127 characters. When the "by" keyword is used in the language, the fields being sorted are built into index style keys. Thus this message may also appear when sorting.
FIX:
Reduce the value of the BY clause field.