Kbase P88213: CONTAINS may not be used with FIND or old style queries. (3318)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/07/2004 |
|
Status: Unverified
SYMPTOM(s):
CONTAINS may not be used with FIND or old style queries. (3318)
Running code similar to:
FOR EACH customer NO-LOCK WHERE NAME CONTAINS "A":
DISPLAY NAME.
END.
Using v6q startup parameter
** <program> Could not understand line <number>. (196)
A a word index and a character index were defined on the field 'Name'.
CAUSE:
The progress session was started with the Version 6 Query -v6q startup parameter. The Version 6 Query (-v6q) parameter directs the Progress server to use only a single index when resolving a FOR EACH statements. The -v6q parameter causes cursor repositioning with FOR EACH statements.
FIX:
Do not use the Version 6 Query -v6q with a FOR EACH statement.