Kbase P108341: Will 4GL CONTAINS phrase search each element of a character array field?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
Will 4GL CONTAINS phrase search each element of a character array field?
GOAL:
Is each array element indexed with a single search?
FIX:
If an array filed has a WORD-INDEX defined on it, then the entire array is indexed. Searches cannot be done on individual elements in the array.
Syntax:
Correct: WHERE ARRAY-FLD CONTAINS "ball"
Incorrect: WHERE ARRAY-FL[3] CONATINS "ball".