Kbase 33492: Error 7888 when SQL-92 queries an array datatype field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P3492
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Array reference/update incorrect. (7888)
Error 7888 when SQL-92 queries an array datatype field
CAUSE:
If reaching the error, verify that the SQL-width is set appropriately for the field.
The default SQL width for array datatype fields is calculated by the following formula:
((4GL_format * 2) * number_of_extents) + (number_of_extents * 2)
So for example, the following will be true:
4GL Format Extents SQL Width
x(2) 4 24
For the array in the above example, if the total amount of characters in all the elements of this array field are 24, you will get the error (7888) when trying to query the field. This is due to a known issue in Progress 9.1x.
FIX:
To avoid the error, set the SQL width of the array field to:
<the total maximum number of characters in the array> + 3.