Kbase 20872: Character Client Error 7888 With SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/06/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Progress Character Client
Progress SQL-92 ODBC
ODBC Error:
[MERANT][ODBC PROGRESS driver][PROGRESS]Array reference/update incorrect. (7888)
CAUSE:
The width of the field is the cause. If the SQL-WIDTH property is defined for the array, the width must allow enough space to contain all array elements after they have been converted to character form, plus some delimiting characters. The initial width set by the underlying schema code uses the array column's FORMAT and EXTENT sizes to estimate the value. That estimated value might be too small in some cases.
FIX:
Follow these steps to change the field width value:
- In the Character environment:
1) Start Data Administration and connect to the database.
2) Select menu Schema > SQL Properties.
3) Select the table.
4) Set the width value.