Kbase 19128: Error 3626, Field Size Limitation w/SQL89 Engine With Array
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/15/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3x
Progress 9.x
MERANT 3.70 32-BIT Progress SQL-89
MERANT 4.0 32-BIT Progress SQL-89
All Supported Operating Systems
SYMPTOM(s):
Column name - <colname> with subscript <cnameindex> exceeds the maximum column name size <cbmaxcolname> (3626)
Column Name - <colname> with subscript <1> exceeds the maximum column name size <32> (3626)
If an array field in the data-dictionary with 32 characters in its name, it will return the error 3626.
This limitation does NOT exist in SQL-92.
CAUSE:
This is a limitation of SQL89 and the way around it is to use shorter fieldnames.
FIX:
Either create an array field in your Database with 32 characters in its name. Then type SELECT * FROM <table> in the Procedure Editor or Open Report Builder, select "Reports" > "New" and select the table with the array field.