Kbase P72865: TEXT function Used with Array Field Causes Spacing Problems
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/4/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Using an array field in an update statement and the TEXT function
When extracting text the spacing between lines is incorrect
CAUSE:
The customer was trying to use the TEXT function the same way as it is used in the HTML language. When using an array, they were not getting spaces between different array elements
FIX:
Change the UPDATE statement to use the VIEW-AS EDITOR syntax instead of using an array field with the TEXT function.